Question : oracle session date format
Answered by : vastemonde
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;
Source : | Last Update : Sun, 08 Aug 21
Answered by : vastemonde
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;
Source : | Last Update : Sun, 08 Aug 21