DSXchange

Posted: **Mon Aug 07, 2006 8:43 am**

HI All,

How to convert Static Date to Date format.

I have a specific requirement to insert the constant date into the oracle 9i

How to insert the constant value '31-Dec-9999' using the transformer stage into the oracle 9i table

Thanks,
srini

Posted: **Mon Aug 07, 2006 9:00 am**

Did you try hardcoding '9999-12-31'?
What does it say?

Posted: **Mon Aug 07, 2006 2:10 pm**

USE
Oconv(Iconv("9999 12 31", "D-YMD[4,2,2]"),"D DMY[,A3,]") in the transformer

Posted: **Mon Aug 07, 2006 10:23 pm**

Hard code it. Use user-defined SQL to incorporate a TO_DATE function in the INSERT statement.

Posted: **Mon Aug 07, 2006 10:27 pm**

No need for User Defined SQL. The proper datatype choice will generate the appropriate SQL in the OCI stage automatically.

Posted: **Mon Aug 07, 2006 10:43 pm**

... unless your hard coded value does not match the default date picture for Oracle.

Posted: **Tue Aug 08, 2006 6:14 am**

Simple enough - make it match!

DSXchange

DATE CONVESRION PROBLEM

DATE CONVESRION PROBLEM