When use this query in mdb
select dateadd (ss, tkt.open_date, '1/1/1970') from call_req tkt where tkt.ref_num='the-ticket-id'
we found that the open_date is one hour difference from the ticket open date displayed on web interface. Why?
Release : 17.2, 17.3
Component : SDM - MDB/Database
This query is for East Standard Time and if your time zone is one hour difference from EST, then you would need to adjust this query accordingly.
For example, if your time zone is CST, then the query should look like
select dateadd (ss, tkt.open_date+3600, '1/1/1970') from call_req tkt where tkt.ref_num='the-ticket-id'