devxlogo

Conversion of Unix Epoch Time in SQL

Conversion of Unix Epoch Time in SQL

Question:
How do I convert the Unix epoch time into a readable date/time format?

Answer:
Informix doesn’t have a built-in function that I know of for this. However, a function or stored procedure to do the conversion should be pretty simple to write—as long as you can find the correct formula for the conversion.

devx-admin

Share the Post: