[dbo].[secs2date]

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

Properties
Parameters
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION dbo.secs2date(@numSeconds bigint)returns varchar(20)
as begin
return convert(varchar(20), dateadd(ss, @numSeconds, '01-01-1970 00:00:00'), 101)
end

GO

Uses

Used By

[dbo].[al_compliance_status_view]