Re: Proposal for two (or more) new time and date functions

[Michael Widenius]

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