The TimeZone setting of the OS (SunSOlaris 10) , that Our sybase ASE server runs on, is being changed from CT to GMT. For ages now, all our applications and data are at CT. We want to retain this and avoid overhead of conversion.
Question 1 : I want to know if there is any option to reset sybase server time independent of the OS time. Meaning that even though the OS time is at GMT, getdate() function returns time in CT. We want to avoid doing this conversion in the clients.
Question 2 : If it is not possible or practical to change syb server time, can we override the getdate() function ?