开发者

How can I accurately convert an INFORMIX-SE audit table column which stores UNIX timestamp[INT] into date and time?

开发者 https://www.devze.com 2023-01-05 13:03 出处:网络
INFORMIX-SE: SE allows you to create an audit file for any table. The audit file has the same schema as the table being audited plus a header consisting of several columns, one of them being a_time I

INFORMIX-SE:

SE allows you to create an audit file for any table. The audit file has the same schema as the table being audited plus a header consisting of several columns, one of them being a_time INTEGER, which contains a UNIX timestamp of when the row was added, updated or deleted. UNIX timestamp is an INTEGER value corresponding to the number of seconds since 1970-01-01T00:00:00Z. Can anyone come up with an algorithm which can accurately convert these seconds int开发者_StackOverflow中文版o a date and time?


Here is an algorithm that shows you how to do it: http://forums.mrplc.com/index.php?showtopic=13294&view=findpost&p=65248

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号