DB2 date and time column

[kogads]

Hi All,
When i read the date and time column from DB2/UDB API stage i see the date as 12436 (2002-01-17) for date and 58384 (16:13:04) for time column instead of 2002-01-17 for DT and 16:13:04 for Time.These columns are loaded into seq file and the rarget data looks like 12436 for Date and 58384 for time.Pleae help.

Thanks in advance.

[vinothkumar]

Use DateFromDaysSince function. Give the first argument as the the value you are getting from date and second argument as '1970-01-01'

[dhelsley]

Define the input column as VARCHAR and DataStage will not convert it to Universe's internal format.

[DSguru2B]

Or just use the OCONV() function to convert it from internal to whatever format you like.

[chulett]

Use DateFromDaysSince function.

No such thing in a Server job.

[kogads]

Thank You very much for your reply.It worked for me when defined as varchar.