Search code examples
sqldatetimeinformixepoch

convert date unix to timestamp

I want to convert type date unix to timestamp in Informix. My column date1 contains values as 1598915961, 1598911249, 1598911255...

expected output: 2020-02-13 15:00:00

How should I do it, please?

Solution

  • In Informix, you can use dbinfo() and 'utc_to_datetime':

    select dbinfo('utc_to_datetime', myepoch)