[dev] Windows address book dates...

Jan Schneider jan@horde.org
Sat, 10 Nov 2001 10:12:55 +0100


Zitat von Michael Cochrane <mike@graftonhall.co.nz>:

> Hi Jan..
> 
> Well i'm still having issues with the fact that the dates are stored as
> 64 bit
> values make it very difficult to do any usefull operations on them, ie
> getting
> them from the number of 100ns persiods since some date ages ago to the
> current date.
> 
> But MySQL hangles 64 bit values on (as i understand it) all platforms
> (certianly
> win32)... is there some nice way i can check to see if a mysql server has
> been
> configured for pref or logs or something and if so do the calculations
> via
> queries on that... or do we just hold of importing birthdays and
> anniversary
> dates until i have coded a efficient 64 bit support some other way?

That's a bad idea because it makes importing even more platform dependent 
than it already is right now. 

I think we really don't need ns or even ms perhaps even not seconds. So why 
not reading the timestamp as a string from the addressbook and strip the 
last 3 or 6 digits before converting to an integer? 

Jan. 

:::::::::::::::::::::::::::::::::::::::: 
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::