Answers for "default format of date in oracle"

SQL
3

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;
Posted by: Guest on August-01-2021
0

oracle default date format

SELECT
  TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
  dual;
Posted by: Guest on March-15-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language