Showing posts with label dates. Show all posts
Showing posts with label dates. Show all posts

Monday, 19 October 2015

How to specify dates in sql scripts.

Always use the ISO 8601 date format

yyyy-mm-ddThh:mm:ss[.mmm]
You must specify everything except the [.mmm] e.g. 2014-12-24T00:00:00