Создание функции для перевода unix-времени в привычный вид
CREATE FUNCTION [dbo].[UnixTimeToNormal]
(
@UNIX_TIME int
)
RETURNS datetime
AS
BEGIN
declare @OutputDate datetime
-- Using dateadd to add seconds to 1970-01-01
select @OutputDate = dateadd(ss,@UNIX_TIME,'1970-01-01')
return @OutputDate
END
CREATE FUNCTION [dbo].[UnixTimeToNormal]
(
@UNIX_TIME int
)
RETURNS datetime
AS
BEGIN
declare @OutputDate datetime
-- Using dateadd to add seconds to 1970-01-01
select @OutputDate = dateadd(ss,@UNIX_TIME,'1970-01-01')
return @OutputDate
END