Convert stamp_time to DateTime

Submitted by gpnunes on 2010-11-23

Hi,
I'd like to create a report, and I need to know how can I convert the stamp_time collumn to datetime.

Thanks a lot.
Gustavo

Hello,

The stamp_time is basically a Unix time stamp, so if you use MySQL you can use the FROM_UNIXTIME() function to convert it to datetime.

Regards,
Michał

and if you are using MS SQL it's DATEADD(s, stamp_time, '19700101') :)