Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Update a date field using ADO

Update a date field using ADO

From: Francesco <jazz74_removeThis_at_infinito.it>
Date: Thu, 18 Oct 2001 12:40:19 +0200
Message-ID: <9qmad1$hpm$1@fe2.cs.interbusiness.it>


Hi everybody, that's the big trouble: I use ADO with oracle (using OLEDB connection), and I get an error while I try to update a date field: checkData() return a Date in UTC format. (Wed Jul 31 00:00:00 UTC+0200 2002)

var rs=Server.CreateObject("ADODB.recordset");

rs.Open("select * from TABLE where PK_FIELD=100000",cn);
rs.Fields("data_nascita").Value=checkData("31/7/2002");
rs.Update();
rs.Close;

Where can I find good articles or forums about using ADO with Oracle? Thanks in advance.

Francesco Received on Thu Oct 18 2001 - 05:40:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US