Actually, all times in the server are stored in GMT. The timestamp values are number of seconds since Jan 1, 1970 GMT.
Regardless of the timezone you specify or enter the value in, the value that the AR System stores and returns is in GMT. It is the client responsibility to map it to the desired timezone. This is why setting the User Preference for timezone works just time. The clients translate to the correct target timezone – whether it is Australia or New Zeland (or Timbuktu). Now, you client programs are probably just using system environment settings and using the timezone of the OS environment in which they are running. They are using system utilities which automatically adjust the time for the environment timezone. If they were not doing this, then all times would have always being in GMT anyway. So, if you set the environment to say the US Pacific Timezone, you would likely find all your utilities would suddenly be doing all operations in PST – accurately in that timezone, automatically. Again, because the server has all values in GMT and you are using system routines that are automatically adjusting. To fix this, you need to look at the operations being done and determine whether they should be performed in GMT (and then configure that in your calls) or in some other timezone (and configure that in your calls). Stop just accepting the system environment default. NOTE: This includes calls by OS time calculate functions! I hope this helps, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Monday, June 29, 2015 11:24 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Time Zone! ** Unless things have changed since I worked heavily on date and time functions in Remedy (including at the db level), they are all stored at the setting of the server. The client is then responsible for adjusting to the local timezome. The third party systems will be responsible for figuring out their timezone and adjusting the server time accordingly. HTH. Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.com<mailto:bgoralc...@gmail.com> On Mon, Jun 29, 2015 at 7:38 AM, Karthick S <karthick...@gmail.com<mailto:karthick...@gmail.com>> wrote: ** Hi All, Multiple Time Zone! We have remedy server located in Australia. Currently our business is planning to use the same instance for New Zealand. Our requirements is to have different time setting so that system automatically calculates the times as per the zones. I tried the user preferences available in remedy. I created user profiles like locale as NZ & AU. It worked and showed the times as NZ time zone n AUS time zone. But still not met our business requirements because those date calculations are used by other third party applications but still those date n times are still as Australian time. ARS 7.1 SQL 2005 Please help me out guys! Karthi -- Thanks and Regards, Karthick S _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"