Oracle Date Formats examples

The below are the mostly used oracle date formats:

MM/DD/YYYY HH.MI.SS – 01/23/2014 08.41.56
MM/DD/YYYY HH24.MI.SSFF – 01/23/2014 08.41.56066000
MM/DD/YYYY HH24.MI.SSXFF – 01/23/2014 08.41.56.066000
MM/DD/YYYY HH24:MI:SS AM – 01/23/2014 08:41:56 AM
MM/DD/YYYY HH24:MI:SS PM – 01/23/2014 08:41:56 AM

Please add if you know any other oracle date formats in the comments area.

Leave a Reply