Re: how to insert datetime in PRO*C
From: Aniruddha Kortikar <kortikar_at_mipos2.intel.com>
Date: 23 Nov 92 23:07:58 GMT
Message-ID: <By6yxD.81s_at_inews.Intel.COM>
Date: 23 Nov 92 23:07:58 GMT
Message-ID: <By6yxD.81s_at_inews.Intel.COM>
One has to use
insert into .... values :v1,:v2,todate(:v3,'mm/dd/yy hh24:mi') while preparing
the sql statement. and NOT while executing the statement as in
exec sql execute :stmt using ....,to_date(....)
Aniruddha Kortikar(kortikar_at_mipos2.intel.com)
E-mail : kortikar_at_mipos2.intel.com | A billion here, a billion there ... Phone(W): 408 765 5515 | pretty soon it adds upto real money.Received on Tue Nov 24 1992 - 00:07:58 CET
-------------------------------------------------------------------------------