you let them input it, they can mess it up, user error, one more thing
to tech support.
either way is fine, but somethign that is easy to abstract from a "dumb"
customer is always nice!
tony
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:52 PM
To: CF-Talk
Subject: RE: Compensating for Server Time
Yes you can detect their time zone everytime they login or what I've
done in the past is to build it in to the users profile, so that the
user has the ability to select the time zone their in when they
create/update their profile.
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:38 PM
To: CF-Talk
Subject: RE: Compensating for Server Time
but how are you going to *KNOW* the persons local time?
_javascript_ is the only way.
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:35 PM
To: CF-Talk
Subject: RE: Compensating for Server Time
If you want to it directly from SQL you can create a function and call
that from your sql query
create function localtime (@gmtdate datetime, @timezoneoffset int)
returns datetime
As begin
declare @localtime datetime
select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate)
return @localtime
end
Then it can be called like this
select localtime(getdate(), 3)
Tim
-----Original Message-----
From: cf-talk [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 4:54 PM
To: CF-Talk
Subject: RE: Compensating for Server Time
Does that work in SQL 2000?
I've always used _javascript_ at logon to determine the time zone of the
user's computer. I then store the time zone offset in a cookie or
session/client variable. I then use a UDF to convert the time from the
SQL server to that user's local time.
If there was a way to do this all in one single shot via SQL as it seems
you have a solution for below I'd love to try it out. Unfortunately I
can't seem to make the example you gave below work in SQL 2000.
-Novak
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 12:55 PM
To: CF-Talk
Subject: Re: Compensating for Server Time
Chris Montgomery wrote:
>
> What's the best way to compensate for time on a server in a hosted
> environment when the time is set to a different time than a user's
local
> time zone? Ex: client is in Central Time, server is on Eastern Time
(one
> hour ahead); client wants everything to reflect local time.
I use the AT TIME ZONE functionality from SQL, it even
compensates for daylight savings time:
testDB=> select '2003-12-31 12:00:00' AT TIME ZONE 'cet';
timezone
---------------------
2003-12-12 12:00:00
testDB=> select '2003-07-31 12:00:00' AT TIME ZONE 'cet';
timezone
---------------------
2003-06-12 11:00:00
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
