TMACUL

CA SDM Oracle convert date - call_req - cr - open_date/close_date

Blog Post created by TMACUL Champion on Dec 15, 2016

How to convert date on Oracle

 

TO_DATE('19700101','yyyymmdd') + (cr.open_date/24/60/60) opendate,

 

 

select

 

t.name, s.sym as status,
enduser.last_name as usuario_final,
analista.last_name Analista,

grupo.last_name GrupoSolucionador,
ctg.sym as categoria,
TO_DATE('19700101','yyyymmdd') + (cr.open_date/24/60/60) opendate,
TO_DATE('19700101','yyyymmdd') + (cr.resolve_date/24/60/60) resolve_date,
TO_DATE('19700101','yyyymmdd') + (cr.close_date/24/60/60) close_date,
cr.active_flag,

cr.summary,

cr.ref_num,

cr.type


from call_req cr
inner join ca_tenant t on t.id = cr.tenant
inner join cr_stat s on s.code = cr.status
inner join ca_contact enduser on cr.customer = enduser.contact_uuid
left join ca_contact analista on cr.assignee = analista.contact_uuid
left join ca_contact grupo on cr.group_id = grupo.contact_uuid
left join prob_ctg ctg on cr.category = ctg.persid

Outcomes