Question: how to change nls_date_format in oracle?
Answer: ALTER SESSION SET NLS_DATE_FORMAT = 'HH24:MI:SS'; select sysdate from dual; You can change the way that a date or timestamp column is display at any time by altering your session to re-set nls_date_format.