/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

0 vote188 views1 answer
Having all mysql
SQL
7 votes142 views3 answers
Select latest entry in sql table
SQL
0 vote127 views1 answer
Full syntax inner join
SQL
0 vote141 views1 answer
Get all employees if name ends with in sql
SQL
1 vote130 views1 answer
Sql only five first row
SQL
0 vote135 views1 answer
Sql server manager close connection
SQL
16 votes146 views3 answers
Update table from another table
SQL
0 vote128 views1 answer
Dump only schema
SQL
0 vote137 views1 answer
Search column name sql
SQL
3 votes86 views2 answers
Mysql sum with condition
SQL

Share