HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

sql function to convert posix timestamp to date	Mark DIamond	2006-08-16 13:36:08
Hi, I have some text data that contains posix timestamps (long integer representing # seconds since 1970). I looked through the date functions and didn't see one that could take a posix timestamp. Can you recommend how I could convert it into a sql date/timestamp? Thanks, Mark
Re:sql function to convert posix timestamp to date	HXTT Support	2006-08-16 15:49:55
Paste or email us a data line, which contains posix timestamps :)
Re:Re:sql function to convert posix timestamp to date	Mark	2006-08-17 11:56:08
Timestamp -------------- 1110018000
Re:Re:Re:sql function to convert posix timestamp to date	HXTT Support	2006-08-17 20:59:19
The latest package supports POSIXTOT and TTOPOSIX for POSIX timestamp conversion. For instance, select POSIXTOT(timestamp) as ts from youTable.
Re:Re:Re:Re:sql function to convert posix timestamp to date	Mark	2006-08-17 23:19:55
thank you for your response. I will try it.

Email: