[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)
@var_numSeconds	float	8

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION secs2date
(
    @var_numSeconds float(53)
)
RETURNS datetime
AS
BEGIN
    DECLARE
        @vartime datetime
    SELECT @vartime = CAST(@var_numSeconds / 24 AS float(53)) / 60 / 60 + CONVERT(datetime, '01-01-1970', 105)
    RETURN @vartime
END
GO

Uses

Used By

[dbo].[al_bi_agent_disc_view]
[dbo].[al_bi_compliance_status_view]
[dbo].[al_bi_disc_batch_view]
[dbo].[al_bi_disc_software_view]
[dbo].[al_bi_drcs_content_type_view]
[dbo].[al_bi_language_view]
[dbo].[al_bi_owned_res_view]
[dbo].[al_bi_platform_view]
[dbo].[al_bi_product_rights_view]
[dbo].[al_compliance_status_view]