DATE CONVESRION PROBLEM

ysrini9 · Post by **ysrini9** » 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

kris007 · Post by **kris007** » Mon Aug 07, 2006 9:00 am

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

panic · Post by **panic** » Mon Aug 07, 2006 2:10 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Aug 07, 2006 10:23 pm

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

chulett · Post by **chulett** » 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.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 07, 2006 10:43 pm

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

chulett · Post by **chulett** » Tue Aug 08, 2006 6:14 am

Simple enough - make it match!