two timestamp formats ???

Docstone · Post by **Docstone** » Mon Oct 01, 2007 2:08 pm

Hi Team!

i tried to query some statistical data out of the databases and found something confusing me!

in table "_faqdata", field "datum" the Thimestampformat is "JJJHMMDDHHMMSS" AS VarChar. thats ok for me!

but in the table "_faqvisits", the field "last_visit" is filled with an INT figure, which i can hardly interpret.

Please give me some hint to transpond this into a "normal" timestamp!

greetings,

JÃ¶rg

Post by **Thorsten** » Tue Oct 02, 2007 7:15 am

Hi,

this has historical reasons. We'll change this in the future.

bye
Thorsten

Docstone · Post by **Docstone** » Tue Oct 02, 2007 9:58 am

Hi Thorsten!

can you tell me how to convert this INT - Number to some "understandable" timestamp?

cu,
JÃ¶rg

Post by **Thorsten** » Tue Oct 02, 2007 1:36 pm

Hi,

it's a UNIX timestamp.

bye
Thorsten