GetOffsetTime

CREATE FUNCTION GetOffsetTimeByDateTime  ( @date datetime) 
RETURNS int  AS 
BEGIN
declare @rev int
select @rev = DATEDIFF (ss,convert(datetime,convert(varchar(10),@date)),@date)
return @rev
END

CREATE FUNCTION GetOffSetTimeByTime(@time varchar(8))
RETURNS int AS 
BEGIN
declare @rev int
select @rev = datediff(ss,convert(datetime,'1900-01-01'),convert(datetime,'1900-01-01  '+@time))
return @rev
END