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

Question

Where can I find the documentation for each of these formats?

Answer 1

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