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ł Log in to post comments and if you are using MS SQL it's DATEADD(s, stamp_time, '19700101') :) Log in to post comments Right, thanks for the hint :). Regards, Michał Log in to post comments Log in to post comments
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ł Log in to post comments
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'):)Right, thanks for the hint :).
Regards,
Michał