Z63_TIME, Z64_TIME, Z65_TIME

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We want to know when specific z63, z64, or z65 sessions were created.
We can see the Z63_TIME, Z64_TIME, or Z65_TIME but don't know how to interpret it.
Can you please help us with this?

Resolution:
There are two times in these records: the Z63_TIME, Z64_TIME, and Z65_TIME and the Z63_START_TIME, Z64_START_TIME, and Z65_START__TIME. The latter is the time the session started and the former, the time the Enter key was last pressed.
Both of these 10-digit times are the number of seconds since January 1, 1970.
Each day has 86,400 seconds in it.
So if you have a time "1019658297" that's 1,019,658,297/86,400 = 11,801 days past Jan. 1, 1970.

To convert the unix time into a readable time, go to: http://www.onlineconversion.com/unix_time.htm .
There's a convertor into which you can enter the "Unix TimeStamp" and get a readable date/time.