1.2k questions

1.4k answers

361 comments

339 users

Categories

Sidebar
+1 vote
2.5K views
by mike-r-7535 (13.8k points)
edited 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

by mike-r-7535 (13.8k points)
...