|
|
Posted by Tony on 06/09/05 03:41
"Mariusz Jedrzejko" <mariosoft@post.pl> wrote in message
news:42a75186@news.home.net.pl...
>
> Uzytkownik "Nicholas Sherlock" <n_sherlock@hotmail.com> napisal w
> wiadomosci
> news:d447q1$bf6$1@lust.ihug.co.nz...
>> laredotornado@zipmail.com wrote:
>> > Hi, I was reading that the MySQL data type TIMESTAMP has a range of the
>> > beginning of 1970 to sometime in the year 2037. Someone mentioned to
>> > me this has to do with milliseconds represented by a long data type.
>> > My question is, what will happen in the year 2037 when that data type
>> > "rolls over"? Are we talking mass hysteria? Dogs and cats living
>> > together?!
>>
>> Delphi has the right idea: Time/date is stored as a double precision
>> floating point which represents the amount of days since a certain
>> period: As the years go on, the smallest interval that can be
>> represented grows larger, but the range is practically infinite (Goes
>> all the way to 12/31/65535, where 65535 is the year).
>>
>> Cheers,
>> Nicholas Sherlock
>
> Sorry
> But it's stupid question. Please read MySQL Users Guide
>
Yeah, MySQL won't be around in 2037 - Microsoft will have assimilated
everyone by then...
Navigation:
[Reply to this message]
|