GMT and local time conversion

[JChanana]

Is there a way in SQL Server to convert GMT time to a local time by designating a time zone. I do not want to convert to the antive time zone but identifya time zone to conver to. I believe GMDATE convert to GMT, I need to convert from GMT to local time given time zone (this needs to take into account whether daylight savings is applicable or not). Is this even possible? Is there another way?

 

[redlam]

not sure if there's anything 'built-in'. i created my own function in sql2000. this might work for you:
create function localtime
(@gmtdate datetime, @timezoneoffset int)
returns datetime
as
begin
declare @localtime datetime
select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate)
return @localtime
end

you can call the function like this:
dbo.localtime(@timestamp, @timezoneoffset)

note: the @timezoneoffset is the number of hours the local time deviates from GMT time.