Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Time Zone

2 posts in General Discussion Last posting was on 2007-04-26 17:31:52.0Z
tim spero Posted on 2007-04-26 15:02:09.0Z
From: "tim spero" <tim.spero@ticketmaster.com>
Newsgroups: ianywhere.public.general
Subject: Time Zone
Lines: 4
Organization: ticketmaster
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: c-69-243-21-130.hsd1.va.comcast.net
X-Original-NNTP-Posting-Host: c-69-243-21-130.hsd1.va.comcast.net
Message-ID: <4630bef1$1@forums-1-dub>
Date: 26 Apr 2007 08:02:09 -0700
X-Trace: forums-1-dub 1177599729 69.243.21.130 (26 Apr 2007 08:02:09 -0700)
X-Original-Trace: 26 Apr 2007 08:02:09 -0700, c-69-243-21-130.hsd1.va.comcast.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5956
Article PK: 1929

We gave two db files running on the same server. is there a way to have one
db use a different time zone than the system time


Stephen Rice Posted on 2007-04-26 17:31:52.0Z
From: "Stephen Rice" <sriceATianywhereDOTcom>
Newsgroups: ianywhere.public.general
References: <4630bef1$1@forums-1-dub>
Subject: Re: Time Zone
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: srice-xp2.sybase.com
X-Original-NNTP-Posting-Host: srice-xp2.sybase.com
Message-ID: <4630e208$1@forums-1-dub>
Date: 26 Apr 2007 10:31:52 -0700
X-Trace: forums-1-dub 1177608712 10.25.98.210 (26 Apr 2007 10:31:52 -0700)
X-Original-Trace: 26 Apr 2007 10:31:52 -0700, srice-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5957
Article PK: 1930

No, times are retrieved from the server or provided by the application. I
would recommend you always use UTC in the database and convert to local time
as required.

--
/steve
Stephen Rice
Sybase iAnywhere

"tim spero" <tim.spero@ticketmaster.com> wrote in message
news:4630bef1$1@forums-1-dub...
> We gave two db files running on the same server. is there a way to have
> one
> db use a different time zone than the system time
>