Another Date Conversion

rxs0005 · Post by **rxs0005** » Thu Feb 23, 2006 12:43 pm

All

Simple rrequest

Sequntial file has 2006-02-28 00:00:00 i need to put it in ORacle DATE feild how do i do it

Also I have defined the date column on the orcale side in DS as TImestamp 38

Do i have to define it as TIMESTAMP in the metadata defenition on the SEQ stage or is it ok to be varchar

thanks all

rxs0005

chulett · Post by **chulett** » Thu Feb 23, 2006 12:52 pm

If you have defined it as a Timestamp in the OCI stage then you've already got the data in the right format for that. Verify that by checking the generated SQL and the TO_DATE conversion mask.