convert date unix to timestamp

Question

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?

See also [Informix FROM_UNIXTIME alternative](https://stackoverflow.com/q/55600549/15168). — Jonathan Leffler, Sep 04 '20 at 13:42

score 2 · Accepted Answer · answered Sep 04 '20 at 10:11

2

select dbinfo('utc_to_datetime', myepoch)

answered Sep 04 '20 at 10:11

GMB

my epoch is it the column ? @GMB – Jappa Sep 04 '20 at 12:01
@Jappa: yes, indeed. – GMB Sep 04 '20 at 12:02
@Jappa: if your column is called `nb1` in table `table1`, then: `select dbinfo('utc_to_datetime', nb1) from table1` – GMB Sep 04 '20 at 12:07
`DBINFO(‘utc_to_datetime’, table1.nb1)` would work. – Jonathan Leffler Sep 04 '20 at 12:29

score 0 · Answer 2 · answered Sep 04 '20 at 11:05

0

The idea is that you can add the seconds to the date '1970-01-01'. I don't have Informix on-hand, but the syntax is something like this:

select datetime('1970-01-01') + interval date1 second

answered Sep 04 '20 at 11:05

Gordon Linoff

The general idea is correct but Informix throws a number of spanners into the works. The most significant is that it limits the number of seconds that can be added in a single operation to 999,999,999. See [Informix FROM_UNIXTIME alternative](https://stackoverflow.com/q/55600549/15168). – Jonathan Leffler Sep 04 '20 at 13:43

2 Answers2