MVSFORUMS.com

schintala · Posted: Wed Jan 25, 2012 12:35 pm Post subject: DB2 Date and Time Concatenation

Hi,
I have a table that have two columns to store date and time. Date column defined as Date data type where as Time column defined as CHAR(4). We would like to alter the table for an additional column with TIMESTAMP data type. The data to the new column should be populated from exisitng date and time columns. Is there any way Can I do using SQL to poulate the data into this column.

Table
COL1 DATE
COL2 CHAR(4)
COL3
--
NEWCOL TIMESTAMP.

kolusu

schintala · Posted: Wed Jan 25, 2012 2:09 pm Post subject:

Kolusu,
Thank you so much for the reply. Time stored as HHMM in CHAR(4). Yes. We will store the seconds and microseconds are zeros in new column.

kolusu · Posted: Wed Jan 25, 2012 2:14 pm Post subject:

schintala,

Try this untested sql derived from this post

http://www.mvsforums.com/helpboards/viewtopic.php?t=10528&highlight=timestamp

schintala · Posted: Thu Jan 26, 2012 8:33 am Post subject:

Thank you so much. It worked.