Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

REP_TIME_ZONES table...

SOLVED
Go to solution
Highlighted
Ryan Jenkins
Regular Collector

REP_TIME_ZONES table...

OVSD 4.5 SP 13, Oracle 9i (Prod), MSSQL (Dev)

Early in our launch of OVSD we asked our consultant to clean up the rep_time_zones table. This entailed deleting values which we would not need. Now that we are a little more mature in our processes we have found a missing value. Namely PRT or Atlantic Standard Time DST. We have the PRT value, but it doesn't take into account Daylight Savings Time. I would really appreciate it someone would post their rep_time_zones table in Excel format so that we can find this value.

Thanks in advance,
Ryan
3 REPLIES
Robert Champion
Regular Collector
Solution

Re: REP_TIME_ZONES table...

See attached xls from SP17. I am fairly sure that the structure is still the same.

YMMV.

Rob.
Ryan Jenkins
Regular Collector

Re: REP_TIME_ZONES table...

Great, thank you very much. But we seem to have a problem. Apparently OVSD 4.5 doesn't support Atlantic Daylight Time?

There is only one UTC -4 Time Zone and that is PRT, which does not practice Daylight Savings Time.

Does anyone have any suggestions?
Ryan Jenkins
Regular Collector

Re: REP_TIME_ZONES table...

Do we have any Canadian users in the forum who have experienced this?

Looking for work arounds as a big part of our workforce is located in Atlantic Canada.

Thanks.
//Add this to "OnDomLoad" event