I have a date field in my sequential file in YYYY-MM-DD HH:MI:SS format. when i try to insert this record to my oracle table through OCI stage using my udf sql..which has statement like
insert into datenew values(to_date(:1,'YYYY-MM-DD HH:MI:SS'));
i get an error in inserting this way..
do help me..sooon
Programmer Analyst,
Cognizant,
Chennai.
Oracle OCI date Problem
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think you need a slightly different date picture (HH24?).
It is insufficient, on this list, to post "I received an error" - to be of any assistance in diagnosing it is important to provide as much information as possible about the error, in particular any error codes and actual text messages that appear.
Try declaring the date column to be TimeStamp in DataStage and using generated SQL. DataStage will generate SQL using a TO_DATE function.
This reply (in more detail) was posted on datastage-users yesterday; it should appear in the archives (on this site) very soon.
Edited by - ray.wurlod on 01/07/2003 22:14:13
It is insufficient, on this list, to post "I received an error" - to be of any assistance in diagnosing it is important to provide as much information as possible about the error, in particular any error codes and actual text messages that appear.
Try declaring the date column to be TimeStamp in DataStage and using generated SQL. DataStage will generate SQL using a TO_DATE function.
This reply (in more detail) was posted on datastage-users yesterday; it should appear in the archives (on this site) very soon.
Edited by - ray.wurlod on 01/07/2003 22:14:13