Oracle OCI date Problem
Posted: Tue Jan 07, 2003 9:54 pm
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.
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.