tme zone problem

Article View: borland.public.cppbuilder.database.ado

Article #289

Back to borland.public.cppbuilder.database.ado Previous Next

#289

From: Tales Aguiar
Date: Thu, 08 Jun 2006 20:01

12 lines
1397 bytes

In my work, we have a website that must be upgraded to work with time zones.
The Oracle database server we use has support to time zone with a special
data type named 'timestamp with local time zone'.
When we configure the oracle session to work with time zone as GMT -3:0
(alter session set time_zone = '-3:0'), all date values are converted.
The problem is that when we use ADO this configuration is ignored. ADO
always uses the OS time zone to convert the dates.
We need to configure many Oracle connections to work with diferent time
zones in the server.
How do I have to configure it?

Tales Aguiar

Technical Details

Message-ID: <44888247@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news2.volia.net!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,8448f349252f98d8,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Tales Aguiar" <tqueiroz@engesis.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: tme zone problem
Date: Thu, 8 Jun 2006 17:01:05 -0300
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
NNTP-Posting-Host: 201.58.217.156
Message-ID: <44888247@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1149796935 201.58.217.156 (8 Jun 2006 13:02:15 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news2.volia.net!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail