jpierson/min-max-dates.md

Last active May 14, 2024 12:16

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jpierson/af2f9ce8b0abc2fbd89b3a032e56987a.js"></script>
Save jpierson/af2f9ce8b0abc2fbd89b3a032e56987a to your computer and use it in GitHub Desktop.

Download ZIP

A summary of min/max date values used by various systems

Raw

min-max-dates.md

Summary of Min/Max date values for various systems

System/Type	Min	Max	Notes
.NET (DateTime)	1/1/0001 12:00:00 AM	12/31/9999 11:59:59 PM
T-SQL (datetime)	January 1, 1753	December 31, 9999	Default value is 1900-01-01 00:00:00
Oracle (DATE)	0001-01-01	9999-12-31
Oracle (TIME)	00:00:00	24:00:00
Oracle (TIMESTAMP)	0001-01-01-00.00.00.000000	9999-12-31-23.59.59.999999
ISO 8601	1583-01-19T0:00:00Z	9999-12-31T023:59:59Z

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment