Hi,

How can I convert an integer to db2 timestamp format? For example, I have the number 1240341010 and would like to convert it to a format like 2009-10-10-05.00.00.000000

Thanks!!

select timestamp(date(1240), time('3:41')) + 010 microsecond
from sysibm.sysdummy1

Lenny

The internal representation of a timestamp is a string of 10 bytes.
Each byte consists of 2 packed decimal digits.
The first 4 bytes represent the date, the next 3 bytes the time, and the last 3 bytes the microseconds.

Lenny

thanks for the response -- this is what I get back :

db2 "select timestamp(date(1240), time('3:41')) + 010 microsecond from sysibm.sysdummy1"

1
--------------------------
0004-05-24-03.41.00.000010


It should give -- 2009-04-21-19.10.10
I forgot to mention that the integer is the number of seconds since Jan 1, 1970... in any case, I appreciate the response!

you storing timestamp in integer field?

Someone i used to work with wrote a program that inserts time into a table in integer format.. bad idea I know!

It's Funny

Lenny Kh.

great, thank you!!

No problem !