What is the best way to handle time zones

Thread View: borland.public.cppbuilder.database.multi-tier

4 messages

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

4 total messages Started by Claude Thu, 01 Jul 2004 14:20

#216

Author: Claude
Date: Thu, 01 Jul 2004 14:20

7 lines
1201 bytes

I am looking for the best way to handle time zones.
The database has date/time. in GMT.
The client may be in any timezone when retrieving a schedule.
The schedule may be viewed using their local time or viewed using another
time zone.
I was thinking of doing a conversion on the server side but the client side
knows the zone.

Re: What is the best way to handle time zones

#217

Author: Mark Guerrieri
Date: Thu, 01 Jul 2004 14:48

20 lines
1694 bytes

I had this exact issue.  I store the times GMT on the server, and I built a
light-weight COM object for the client that handles Time Zone conversions
to/from any Time Zone.  I use TADO... classes on the client, so I wrote
event handlers for the date field TField decendants that returns the
converted values to grids, reports, web pages, etc...

Mark

"Claude" <claude@dev.scomage.com> wrote in message
news:40e41d7e$1@newsgroups.borland.com...
> I am looking for the best way to handle time zones.
> The database has date/time. in GMT.
> The client may be in any timezone when retrieving a schedule.
> The schedule may be viewed using their local time or viewed using another
> time zone.
> I was thinking of doing a conversion on the server side but the client
side
> knows the zone.
>
>

Re: What is the best way to handle time zones

#219

Author: Thomas Blankschein
Date: Tue, 06 Jul 2004 07:53

8 lines
1094 bytes

Hi,

> I am looking for the best way to handle time zones.

What Database are you using? I think Oracle (9i) already offers several
functions to handle this problem.

Thomas

Re: What is the best way to handle time zones

#220

Author: Claude
Date: Tue, 06 Jul 2004 14:52

14 lines
1304 bytes

I am using Access and MS SQL Server. Oracle is for the future.

"Thomas Blankschein" <thomas@blankschein.de> wrote in message
news:40ea5a6b$1@newsgroups.borland.com...
> Hi,
>
> > I am looking for the best way to handle time zones.
>
> What Database are you using? I think Oracle (9i) already offers several
> functions to handle this problem.
>
> Thomas
>
>

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