How to run Server in UTC time?

[former_member319447]

Hi All,

Our Linux machine is running on BST time, which is UTC+0 or UTC+1 depending on the time of year.

If we cannot change this (and we probably cannot), how would I run IQ in UTC time?

I see that select connect_property('AppInfo') returns TIMEZONEADJUSTMENT=60. I am not sure what I can do with this info because our apps have their own local time settings for any time zone on the planet.

I see that select now() returns BST time.

I would rather have now() return UTC time so that I can use this in all date calculations. Also I want datediff() to return UTC differences and all other date math to maintain 24 hours per day.

Is there a way to run IQ in UTC time?

[saroj_bagai · Accepted solution]

You can set TZ environment variable in IQ.csh/sh  and then start IQ server
setenv TZ UTC

or

export TZ=UTC

[former_member319447 · Accepted solution]

Well, that was easy. Just like ASE. My brain must be worn out today.