Re: Issue with SQL statement

From: Dr. Frank Ullrich (frank.ullrich_at_heise.de)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 08:22:19 +0200
To: "Moreno, Javier" <JavierMoreno@eaton.com>

Javier,

Moreno, Javier wrote:
> Hi,
>
> I am attempting an insert with dates and I am getting the following:
>
> /*
>
> INSERT into MASTER_Entry VALUES (?,?,?,?,?,?,?) with values E1138132263904 Javier Moreno has become the new Systems Engineer for AMS. 2004-07-22 00:00:00 H B 3018525 2004-04-19 00:00:00
>

Try:

INSERT into MASTER_Entry
VALUES (?,?,to_date(?,'YYYY-MM-DD HH24:MI:SS'),
?,?,?,to_date(?,'YYYY-MM-DD HH24:MI:SS'))

Regards,
     Frank.

--cut 

-- 
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag GmbH & Co KG, Helstorfer Str. 7, D-30625
Hannover
E-Mail: frank.ullrich@heise.de
Phone: +49 511 5352 587; FAX: +49 511 5352 538