Re: Oracle Date Datatype and ODBC

patrick_williams_at_my-dejanews.com wrote in message <71a1ir$5jv$1_at_nnrp1.dejanews.com>...
>Can someone give me an example of setting an Oracle Date datatype using an
>Oracle ODBC driver? I have tried setting the value using the String
>functionality but I always get an exception when I put the record.
>
>Thanks
>
>Patrick Williams
>
>

insert into table (ID,datetimefield) values (1,{ts '1998-11-02 09:13:00'})

ie format of the date field is {ts 'YYYY-MM-DD HH:MI:SS'}. But don't ask me what 'ts' stands for (time-string, maybe?)!

• Bill.