Re: Update a date field using ADO

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Thu, 18 Oct 2001 14:22:35 +0200
Message-ID: <9qmhdl$hlr$1@wanadoo.fr>

probably you can try to set NLS_DATE_FORMAT for the session (alter session stmt), and after give the formatted string instead of using UTC. For exapmle:
altersession set NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS'

rs.Fields("data_nascita").Value="31/7/2002 23:15:00";

"Francesco" <jazz74_removeThis_at_infinito.it> a écrit dans le message news: 9qmad1$hpm$1_at_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 - 07:22:35 CDT