seq file to oracle timestamp

suresh_dsx · Post by **suresh_dsx** » Thu Jul 20, 2006 8:07 am

hi guys,
i got a a flat file contains a column timestamp.
i am trying to send that in target .

i need to convert into character frist ...befroe i convert into a date format bcz my data is flat file .....
can any one give suggestion.......plz give me explantion

kris007 · Post by **kris007** » Thu Jul 20, 2006 8:21 am

What format is your input Timestamp? Is it in acceptable format by Oracle. Else, you will need to use OConv and IConv functions to convert it into a format acceptable by Oracle. Also, How are you inserting data into Oracle. Is it User-defined sql or one of the default update actions available in the OCI stage? If later, then the stage itself wraps the timestamp values in TO_DATE function and you won't have to worry? Did you try doing any of these things and were not able to do so? Any error messages in particular.

More info needed.

suresh_dsx · Post by **suresh_dsx** » Thu Jul 20, 2006 8:31 am

dd/mm/yyyy 00:00:00
that is the format in flat file

chulett · Post by **chulett** » Thu Jul 20, 2006 8:47 am

Ok. Kris asked about five questions and you answered... one.

suresh_dsx · Post by **suresh_dsx** » Thu Jul 20, 2006 8:52 am

hi kris007

did u see that format.this is format.

dd/mm/yyyy 00:00:00

give me some suggestion

thank you

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Jul 20, 2006 8:55 am

Suresh,

Please try and answer all the questions by Kris. You will not be helping yourself by avoiding them.

If one of the members have raised some queries, its most likely that the others will raise the same. and moreover Kris raised those queries to understand your issue.

Please be patient and co-operate.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 20, 2006 10:12 am

All you need to do is to specify an appropriate date picture for the TO_DATE function in your INSERT or UPDATE statement.