cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
993
Views
0
Helpful
2
Replies
mark.rennie1
Beginner

Cisco UCCE Database Timezone

Hi,

 

Within the UCCE Database there is a Agent_Real_Time table that has a series of columns holding various times which I am querying.  E.g. DateTime, DateTimeLastStateChange, DateTimeLastModeChange etc all of time DBDATETIME.  

 

Are these timestamp values always guaranteed to be in GMT/UTC?  Or if I connected to another setup could these in fact be in any local timezone? (e.g. CET, EST etc).

 

I am looking at the Database Schema Handbook for Cisco Unified ICM/Contact Center Enterprise & Hosted but don't see any guidance around this specifically.  

 

I would like to know so that I understand if I need to add logic to do a conversion or not if I script against another database not in GMT.

 

Thanks,
Mark

2 ACCEPTED SOLUTIONS

Accepted Solutions
bill.king1
VIP Collaborator

Majority of the fields store date time as per time zone configured in central controller, except specifically mentioned like StartDateTimeUTC.

View solution in original post

2 REPLIES 2
bill.king1
VIP Collaborator

Majority of the fields store date time as per time zone configured in central controller, except specifically mentioned like StartDateTimeUTC.

View solution in original post

Content for Community-Ad

Spotlight Awards 2021