HowTo explain db-entries for 'date'

[881822]

Hello,

for analyzing purposes I want to retrace some DB-entries. My problem is es explanation of date-formats. For example, in the table 'prg_contacts' I've found the value

'1263938752928' for 'creating_date'

and

'1263938752928' for 'changing_date'

To witch real date conform these values to? How can I convert the db-dates?

[Martin Heiland]

Hi Rene,

those are 64bit signed Long values of UNIX Timestamps that we use through the whole groupware. You can cut off the last 3 digits and calculate the "real" time based on the unix timestamp.

mbraun@mbraun:~$ date -ud @1263938752
Tue Jan 19 22:05:52 UTC 2010

Greetings