DSXchange

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.

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

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

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

vinothkumar wrote:Use DateFromDaysSince function.

No such thing in a Server job.

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