UTC Convert Time Function

				
--**************************************
-- Name: UTC Convert Time Function
-- Description:MS-SQL Function to convert UTC time to local daylight savings.
-- By: Eric Connolly
--
-- Inputs:DateTime in Greenwich mean time you need to edit function for your time offest
--
-- Returns:Local time or daylight savings
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=911&lngWId=5--for details.--**************************************

CREATE FUNCTION [dbo].[Get_UTC_Offset] (@UTCTime DateTime) 
RETURNS DateTime As
BEGIN 
Declare @Year Int
Select @Year = DatePart(Year,@UTCTime)
Declare @BegApr varchar(30)
Declare @EndOct varchar(30)
Set @BegApr = Convert(varchar,@Year)+'-04-01 00:00:00'
Set @EndOct = Convert (varchar,@Year)+'-10-31 00:00:00'
--checks the first day of month in relation to the first Sunday of the month. Sets @AprDay to the appropriate date. For Daylight savings.
Declare @AprDay Int
Set @AprDay =
	Case Datepart(Weekday,@BegApr) 	
	When 1 Then 01
	When 2 Then 07
	When 3 Then 06
	When 4 Then 05
	When 5 Then 04
	When 6 Then 03
	When 7 Then 02
 End 
Declare @DSTStart DateTime
Set @DSTStart = Convert(DateTime,Convert(varchar,@Year)+'-04-'+Convert(Varchar,@AprDay)+' 07:00:00')
--checks the last day of month in relation to the last Sunday of the month. Sets @OctDay to the appropriate date. For Daylight savings.
Declare @OctDay Int
Set @OctDay =
	Case Datepart(Weekday,@EndOct) 	
	When 1 Then 31
	When 2 Then 30
	When 3 Then 29
	When 4 Then 28
	When 5 Then 27
	When 6 Then 26
	When 7 Then 25
 End 
Declare @DSTEnd DateTime
Set @DSTEnd = Convert(DateTime,Convert(varchar,@Year)+'-10-'+Convert(Varchar,@OctDay)+' 06:00:00')
Declare @OffSet DateTime
Select @OffSet =DATEADD(hh, - 5, @UTCTime)
If @UTCTime >= @DSTStart and @UTCTime <= @DSTEnd 
Begin
Select @OffSet =DATEADD(hh, - 4,@UTCTime)
End
Return @OffSet
END