Second -> date conversion

[Peter01]

I have this kind of problem:

I have value of time stored as unix timestamp in db2 table.
I need to convert that value to date format in select clause. Is there any built-in functions to do that?
Stored value (seconds) is of datatype integer.

Peter01
pjkojala@mappi.helsinki.fi

 

[khand]

Hi,

You could try something like this:

select (timestamp('19700101000000') + UNIX_DATE seconds) as DB_TIMESTAMP
from ...
;