Sql时间格式转换

--将c++的time_t的整形转化成datetime类型
--time_t存储的是格林尼治标准时间，有8个时区时间差
ALTER function [dbo].[f_gettimefromtime_t](@daytime int)
returns datetime
as
begin
declare @ret datetime
select @ret=dateadd(second,@daytime+8*3600,convert(datetime,'1970-1-1'))
return @Ret
end
--将datetime类型转化成c++的time_t的整形
ALTER function [dbo].[f_gettime_t](@daytime datetime)
returns int
as
begin
declare @ret int
select @ret=datediff(second,convert(datetime,'1970-1-1'),@daytime)-8*3600
return @Ret
end