tme zone problem

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Tales Aguiar Thu, 08 Jun 2006 20:01

#289

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads