Date Function in Datastage

babuselvan · Post by **babuselvan** » Fri Nov 13, 2009 4:00 am

I need to insert a Date ('31-dec-9999') into my oracle database which has a datatype as Date. How do i do it using Datastage?

gssr · Post by **gssr** » Fri Nov 13, 2009 4:08 am

What datatype are you using to define it the DS

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Nov 13, 2009 4:16 am

DataStage server does not bother about datatypes.

What did you try so far ? What issues are you facing ?

It is better to post specific issues than ask open questions.

You may better refer to the documents before posting.

chulett · Post by **chulett** » Fri Nov 13, 2009 7:29 am

You do it the same way you would do it anywhere else, with the help of a properly configured TO_DATE() function. The stage can automatically generate that for you.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 13, 2009 2:43 pm

If you specify Date as the Data Element, DataStage will expect an internal format date.