On Sun, 18 Apr 2004 13:54:22 -0400, Rhino wrote: > Stormblade (and anyone watching this thread), > > Just watch yourself when deciding between DATETIME and TIMESTAMP; the two > datatypes support very different ranges of values!
Thanks for the heads up! > > According to the manual, DATETIME can store any value between '1000-01-01 > 00:00:00' and '9999-12-31 23:59:59' but TIMESTAMP can only handle the range > '1970-01-01 00:00:00 ' and "sometime in the year 2037". Ugh I did not know this. Well hopefully it won't be a problem. I'll be using datetime for most. I don't currently have a field tracking modifications. I was going to add that. Heh well 2037. Guess I'll do just like the old programmers did and say, by that time this application will have been updated or scrapped or changed. :) > Therefore, even if you really want to use TIMESTAMP but you have to store a > timestamp earlier than 1970 or after 2037, you're going to be out of luck. > Be sure you think about what values you'll have to store before you make a > final choice of the datatype. Right now it would be after 2004 :) > > Rhino -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
