Client Automation Standard Practitioners Forum
cancel

daylight saving - Messenger Server (Oracle 11g DB)

Highlighted
Nigel Futter
Regular Contributor.

daylight saving - Messenger Server (Oracle 11g DB)

Since BST, our reporting is running one hour behind (i.e. GMT). However ReportingServer makes the adjustment and is ok.
Assuming that the change needs to be made for RMS (v7.2), is it one of the values in odbc.ini that will send the events to the Oracle DB in BST (rather than GMT)
2 REPLIES
Steve Berube
Outstanding Contributor.

Re: daylight saving - Messenger Server (Oracle 11g DB)

RMS will and should always be storing data in GMT (and nothing but GMT) all data can be manipulated after for viewing to deal with any timezone issues. But it is very standard practice for date values to be stored as GMT.

If RMS storing as GMT is off, that may be a defect.
Nigel Futter
Regular Contributor.

Re: daylight saving - Messenger Server (Oracle 11g DB)

interesting, I'll submit a call and see what comes back from support as there are some parameters in odbc.ini that mention timezones but not sure if this relates to US timezones or international ones.