Link to home
Start Free TrialLog in
Avatar of drinkwater
drinkwater

asked on

Timestamp conversion

Does anyone know how to convert the btrieve 8 byte timestamp value into it's equivalent displayable format ?

According to the doc :

TIMESTAMP values are stored in 8-byte unsigned values representing septa seconds (10 exp 7 seconds) since January 1, 0001 in a Gregorian calendar.

For example the value 629636495320000000  is 1996-03-28 15:38:52

I need a function which does the conversion
ASKER CERTIFIED SOLUTION
Avatar of Mirtheil
Mirtheil
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial