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
seq file to oracle timestamp
Moderators: chulett, rschirm, roy
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.
More info needed.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: