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
 

No comments:

Post a Comment