Converting integer to date

seanc217 · Post by **seanc217** » Wed May 03, 2006 7:08 pm

I have source data loaded into an Oracle database. The fields I want to convert are defined as number(7) which are defined in my metadata as integers. The format of the date is YYYYDDD. What is the best way of converting them to dates in DataStage?

Thanks for all the help.

ray.wurlod · Post by **ray.wurlod** » Wed May 03, 2006 8:38 pm

In a Transformer stage explore the conversion functions and the casting functions. You can also search the forum, since this question has been addressed in the recent past.

seanc217 · Post by **seanc217** » Thu May 04, 2006 7:48 am

Thanks for the hint on the function.
Here is my derivation. Does this look right?

if DSLink2.CIRAMST_DATE_LAST_BNOTICE =0 then setnull() else DateFromDaysSince(DSLink2.CIRAMST_DATE_LAST_BNOTICE[5,3],StringtoDate(DSLink2.CIRAMST_DATE_LAST_BNOTICE[1,4]:"-01-01"))

Thanks!!

ray.wurlod · Post by **ray.wurlod** » Thu May 04, 2006 2:20 pm

Does it do what you require? I can assert that it's syntactically correct, but can not comment on its semantics.