Date format in oracle example

Date format in oracle:

oracle 24 hour date format:
to_char(sysdate,’MM/DD/YYYY HH24:MM:SS’)

oracle 12 hour date format:

to_char(sysdate,’MM/DD/YYYY HH:MM:SS’)

Sample Query:

select to_char(sysdate,’MM/DD/YYYY HH:MM:SS’) from dual;

476 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *