Table 1

Database systems provide mixed support for date formats. Note that you can reconfigure Oracle to support most date formats, but by default, it only recognizes the first format.

Format Example PostgreSQL MiniSQL MySQL Oracle Sybase
DD-MMM-YYYY 01-Dec-1999 Yes Yes No Yes Yes
MMM DD, YYYY Dec 01, 1999 Yes No No No Yes
MM-DD-YYYY 12-01-1999 Yes No No No Yes
MM/DD/YYYY 12/01/1999 Yes No No No Yes
YYYY-MM-DD 1999-12-01 Yes No Yes No Yes