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