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;