Sidebar

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

+1 vote
1.7K views
asked Mar 25, 2015 by mike-r-7535 (13,650 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

http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

 

Oracle Database Date Format

http://www.dba-oracle.com/t_nls_date_format_sysdate.htm

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.

https://msdn.microsoft.com/en-us/library/ms187928.aspx

(The above table is not complete.)

MySql Database Date Format

https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

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