Home -> Usenet -> comp.databases.oracle -> Pro*C Insert Date/Time

Pro*C Insert Date/Time

From: Charles M Amorose <72520.2374_at_CompuServe.COM>
Date: 1998/01/17
Message-ID: <eZhDrv4I9GA.232_at_nih2naab.prod2.compuserve.com>#1/1 







I am trying to write a program that will read records from MS-SQL 
(6.5)


and the insert them into Oracle (8.0.3.0.0).
 


What is the exact syntax for inserting a date/time field in 
Pro*C?
 


1st Attempt:


   EXEC SQL AT DB_NAME INSERT INTO TEST_ORD


	 values(:ds.tag,


		:omk,

                to_date(:ds.date_time_entered,'DD MON YYYY 


HH24:MI:SS'));
 


2nd:


sprintf(dte,"to_date(\'%s\',\'DD MON YYYY 
HH24:MI:SS\')",ds.date_time_entered);
 


   EXEC SQL AT DB_NAME INSERT INTO TEST_ORD


	 values(:ds.tag,


		:omk,

                :dte);
 




It just dont work?
 


-- 
CMA


Received on Sat Jan 17 1998 - 00:00:00 CET












Original text of this message