1.2k questions
1.4k answers
361 comments
339 users
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