[dbo].[secs2datetime]

(local) > mdb > Scalar-valued Functions > dbo.secs2datetime

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@numSeconds	bigint	8

SQL Script

CREATE FUNCTION dbo.secs2datetime(@numSeconds bigint)returns varchar(20)
as begin
return convert(varchar(20), dateadd(ss, @numSeconds, '01-01-1970 00:00:00'))
end

GO

Uses