/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 votes135 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote207 views1 answer
Mysql get nested records
SQL
0 vote137 views1 answer
SQL SELECT-Klausel
SQL
0 vote146 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote150 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote111 views1 answer
How to check oracle index table
SQL
8 votes136 views2 answers
Select table column name in sql
SQL
-1 vote94 views3 answers
Ubuntu install mssql
SQL
0 vote150 views1 answer
Check if database exists sql
SQL
0 vote162 views3 answers
Mysql regex replace
SQL

Share