Date conversion

sumesh.abraham · Post by **sumesh.abraham** » Mon Feb 04, 2008 2:51 pm

Hi All,

I've a column with data type Timestamp. Please let me know how I can convert it into Oracle Date format (DD-MON-YYYY]

Thanks,
Sumesh

chulett · Post by **chulett** » Mon Feb 04, 2008 2:57 pm

What does your data look like coming in?

ray.wurlod · Post by **ray.wurlod** » Mon Feb 04, 2008 5:15 pm

Why do you want to? Surely if you convert it to a Date data type that's all you need to do. The Oracle Enterprise stage will accept a Date data type and process it properly.

sumesh.abraham · Post by **sumesh.abraham** » Mon Feb 04, 2008 11:52 pm

The data type has been specified as Timestamp in the input data set and I need to write it to an Oracle table which has a column with Timestamp data type.

e.g. The value in the data set is 2007-10-10. My understanding says Oracle expects the above date in the format 10-OCT-2007 and without converting it to the expected format, the insert will not happen.Am I correct? If yes, I want to convert into the Oracle date format before writing to the table. How can I do this in the derivation.

Do you mean to say, the insert will happen if I make the target column data type as Date. Please clarify.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 05, 2008 3:29 am

That's exactly what I mean to say. You could even leave it as Timestamp. They're the same to Oracle. You only need to worry about format if you are supplying string data and applying a TO_DATE function.