Answers for "oracle date time 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;

Posted by: Guest on August-01-2021

sql to char function with date

SELECT
  TO_CHAR( sysdate, 'YYYY-MM-DD' )
FROM
  dual;

Posted by: Guest on March-07-2020

Code answers related to "oracle date time format"