Date Formats
SQLexplorer.DateFormats History
Hide minor edits - Show changes to output
Changed line 9 from:
The normal format for returning dates in SQL is YYYY-MM-DD but you can change this with a cool trick described %newwin% [[http://seedcodenext.wordpress.com/2012/04/21/executesql-date-formats/ | on our blog]].
to:
The normal format for returning dates in SQL is YYYY-MM-DD but you can change this with a cool trick described %newwin% [[http://www.seedcode.com/executesql-date-formats/ | on our blog]].
Added lines 1-9:
!! How does SQL treat dates in queries?
While date formatting can be tricky in SQL, FileMaker's use of parameterized queries (where all the search parameters come at the end of the query) actually makes this a lot simpler. SQLexplorer writes parameterized queries, so you should be all set.
If you'd like to read up on how parameterized queries treat dates, Kevin Frank has %newwin% [[http://www.filemakerhacks.com/?p=4677 | an excellent article]] on this.
!! How does SQL treat dates in results?
The normal format for returning dates in SQL is YYYY-MM-DD but you can change this with a cool trick described %newwin% [[http://seedcodenext.wordpress.com/2012/04/21/executesql-date-formats/ | on our blog]].
While date formatting can be tricky in SQL, FileMaker's use of parameterized queries (where all the search parameters come at the end of the query) actually makes this a lot simpler. SQLexplorer writes parameterized queries, so you should be all set.
If you'd like to read up on how parameterized queries treat dates, Kevin Frank has %newwin% [[http://www.filemakerhacks.com/?p=4677 | an excellent article]] on this.
!! How does SQL treat dates in results?
The normal format for returning dates in SQL is YYYY-MM-DD but you can change this with a cool trick described %newwin% [[http://seedcodenext.wordpress.com/2012/04/21/executesql-date-formats/ | on our blog]].