> 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)
But that requires you to know the time offset instead of the
timezone. And the offset changes with DST.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
