ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Difference on time query

book

Article ID: 237296

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager

Issue/Introduction

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?

Environment

Release : 17.2, 17.3

Component : SDM - MDB/Database

Resolution

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'