oracle session date format

Solutions on MaxInterview for oracle session date format by the best coders in the world

showing results for - "oracle session date format"
Mirko
09 Apr 2018
1ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
2SELECT sysdate FROM dual;
3
4SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;