Blog Stats
  • Posts - 45
  • Articles - 0
  • Comments - 23
  • Trackbacks - 20

 

DateTime field problem with SQL Server

I was trying to push in unix timestamps into a SQL server database this afternoon when ran across something pretty interesting. According to http://www.aspfaq.com/show.asp?id=2451 the unixtimestamp should not be kept in a int field because it will exipire on 2038-01-19 at 3:14:08 AM. That is when it exceeds the maximum int value. Just something to keep in mind in the forthcoming years, else we will have ourselves a repeat of the Y2K issue.
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Feedback

No comments posted yet.


Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

 

 

Copyright © Rishi Pande