/SQL/Oracle default date format

Oracle default date format

Oracle set date format

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT sysdate FROM dual;

SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;

4

Oracle default date format

SELECT
  TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
  dual;

0

Similar codes

2 votes136 views1 answer
Oracle sql query to make column data uppercase
SQL
5 votes167 views4 answers
Traduction
SQL
0 vote148 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
4 votes169 views2 answers
Dbms output
SQL
2 votes147 views2 answers
Postgres select duplicate columns
SQL
2 votes147 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote143 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote144 views1 answer
Cross schema query oracle 2 users
SQL
0 vote147 views1 answer
Oracle synonym procedure
SQL
0 vote149 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL

Share