PDA

View Full Version : You learn something new everyday


cartman
07-07-2011, 04:30 PM
We are testing a new app for one of our customers, and ran across a strange date issue when inserting data from a form into the database. SQL Server's datetime data type doesn't accept dates before 1/1/1753. Here's why:

What is the significance of 1/1/1753 in SQL Server? - Stack Overflow (http://stackoverflow.com/questions/3310569/what-is-the-significance-of-1-1-1753-in-sql-server)

terpkristin
07-07-2011, 10:26 PM
That is so nerdy. And pretty interesting!

/tk

JediKooter
07-08-2011, 10:52 AM
Just use COBOL.

lighthousekeeper
07-08-2011, 11:15 AM
Wow thanks for sharing this tidbit.

JediKooter
07-08-2011, 11:17 AM
The SQL thing I did not know about (very interesting), however, the changing of the calendars back in the mid 1700's, I've known about for a long time.