Genesys Universal Time Algorithm 2

[kiwibaldman]

I'm using data that has been extracted from a Genesys Dialler database through ODBC into an access database and attempting to provide a date and time for when calls have been logged against records. The timestamp for the call is using a 10 digit code however and I've been advised that it may be a universal time stamp ? Has anyone got access to any algorithms I can use in access for deciphering the code ?

 

[Blorf]

Can you post some samples? Maybe some you know the translation to, from occurances you know when took place?

This sounds like it might be interesting.

ChaZ

Ascii dumb question, get a dumb Ansi

 

[kiwibaldman]

ChaZ

I have the following samples but unfortunately no translation:
1073962042
1074131349
1074053203
1074055695

 

[Blorf]

This is of course totally a guess, but assuming that the number represents the number of seconds that have elapsed since January 1, 1970, then you get the following:

1/13/04
1/15/04
1/14/04
1/14/04

The calculation is
#1/1/1970# + (Your Number) / (60 * 60 * 24)

Like I said though, this is just a guess.

ChaZ

Ascii dumb question, get a dumb Ansi

 

[CajunCenturion]

I agree that it's most likely the number of seconds since 1/1/70 00:00, but in addition, since it's Universal time, it may resolve to Zulu time, or GMT (Greenwich Mean Time), which for practical purposes, means that it may not be adjusted to your particular time zone.

A slightly more accurate translation would be to use the following:

ThisDateTimeStamp = DateAdd("s", TheNumber, "1/1/70 12:00 AM&quot

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Blorf]

Excellent point. CajunCenturion's suggestion would also allow you to easily know the hour and seconds of the stamp, while my original suggestion might get tricky.

ChaZ

Ascii dumb question, get a dumb Ansi