oracle set date format

The solution for this is noted below

oracle set date format

Solution

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;

Try other methods by searching on the site. That is if this doesn’t work