List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:November 29 2001 4:53pm
Subject:Re: Proposal for two (or more) new time and date functions
View as plain text  
Hi!

>>>>> "Thomas" == Thomas Spahni <tsp@stripped> writes:

<cut>

>> Not to cite a MS product as useful, but the Jet design allows (for good or
>> bad) the ability to do [date]-[otherdate] directly in SQL.

Thomas> That's exactly the functionality of Julian Day Numbers. The only function
Thomas> needed to display them properly is a function turning the number into the
Thomas> desired display format.

One problem with Julian day numbers is that they don't work correctly
when you change to/from daylight saving time.
(Unix timestamps doesn't have this problem).

Regards,
Monty
Thread
Re: Proposal for two (or more) new time and date functionsbtjones28 Nov
  • Re: Proposal for two (or more) new time and date functionsJeremy Zawodny29 Nov
    • Re: Proposal for two (or more) new time and date functionsMichael Widenius29 Nov
  • Re: Proposal for two (or more) new time and date functionsThomas Spahni29 Nov
    • Re: Proposal for two (or more) new time and date functionsMichael Widenius29 Nov
Re: Proposal for two (or more) new time and date functionsbtjones30 Nov
  • Re: Proposal for two (or more) new time and date functionsSinisa Milivojevic30 Nov