CA Service Management

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