CA SDM::. How to convert CA Format date -  Unix epoch time - seconds date?

Document created by TMACUL Champion on Feb 16, 2017Last modified by TMACUL Champion on Mar 27, 2017
Version 3Show Document
  • View in full screen mode
USE mdb
SELECT ref_num, dbo.secs2date(open_date) as open_date
FROM call_req

 

 

By Jerome Mayer 

 

 

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

[dbo].[secs2date] 

 

 

 

 

select DATEADD(ss, open_date, '19700101') UTCDate
from call_req

 

 

How to convert using javascript:

CA PAM::.Javascript::. getTime() Method 

 

 

 

Summary CA SDM  MS SQL Querys - TSQL 

CABI4::. - BOXI - Web Intelligence - Date Formats - How to change date formats - Como formatar datas 

3 people found this helpful

Attachments

    Outcomes