/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

7 votes113 views1 answer
Grant schema permissions postgres
SQL
0 vote152 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote98 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote118 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote110 views1 answer
Sql server beginning of month
SQL
12 votes102 views2 answers
Delete all nodes neo4j
SQL
2 votes111 views2 answers
Mysql does sentence contain word
SQL
0 vote116 views1 answer
SQL Server date literal
SQL
7 votes118 views1 answer
Show line number in sql server
SQL
0 vote121 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL

Share