Datediff differences in US and Europe
Ruslan Zasukhin
ruslan_zasukhin at valentina-db.com
Sat Jun 30 02:22:39 CDT 2012
On 6/29/12 5:14 PM, "jda" <jda at his.com> wrote:
>
> The dates and times are stored as ulongs
right
> (as Mac dates).
Wrong
There is no any MAC or WIN here.
DATE and TIME values are converted into
format-independent ULONG - 32bit value.
We do not use any "relative to some magic date" tricks.
DATE is stored as is. ABSOLUTE value. 30 June 2012.
Yes, this means in the current our calendar.
> Jon
>
>
>
>
>
> It was my understanding that Valentina ALWAYS stores date
> time information as raw unformatted numbers. Hence my reference to the
> to_days and to_secs functions
> As always, I might be wrong
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
More information about the Valentina
mailing list