The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Client Automation Standard Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

daylight saving - Messenger Server (Oracle 11g DB)

Highlighted
Nigel Futter
Occasional 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
Frequent Visitor

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
Occasional 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.
//Add this to "OnDomLoad" event