Where can I find documentation for date format strings for Java, Oracle, SqlServer, etc?

+1 vote
asked Mar 25, 2015 by mike-r-7535 (13,740 points)
edited Mar 25, 2015 by mike-r-7535
Where can I find the documentation for each of these formats?

1 Answer

+1 vote

First of all, each of these formats are very different, and you may need to lookup the exact format you need for your situation. With QIE 2.0.41 or later, you do have helpful guides within the Code Wizard and the Query Snippets menu for the database format date strings.


For additional documentation, see below.

Java Date Format


Oracle Database Date Format

SqlServer Database Date Format

Until recently, versions of SqlServer required an identifying number which formatted the text accordingly.  You could not create a custom format.

(The above table is not complete.)

MySql Database Date Format

answered Mar 25, 2015 by mike-r-7535 (13,740 points)