Re: INFORMIX SE on LINUX and DATETIME

On Thu, 20 Apr 2000, Jonathan Leffler wrote: > Steve Weiland wrote: > > > I am running SE on LINUX and all is well, except the datetime variables are > > off by 5 hours. The system clock reports correctly, as does date +%Z. I > > tried setting TZ variable to CST6CDT, but that did not change the result. > > Any ideas? > > I've never observed the problem, as someone else said, but... > > If you started sqlexecd at system boot, and it did not have > TZ set correctly, and if you used remote access (sesoctcp) > to get at the SE engine, then I could believe that the SE > spawned by sqlexecd had no TZ set, so it would work on GMT > (UTC) which might just be 5 hours off your CDT time zone. > On Linux one can link /etc/localtime to the appropriate timezone file in '/usr/share/zoneinfo/' and tzset will use that instead. This probably only works with newer versions of glibc but I have no older ones to look at the moment. /J\\ -- Jonathan Stowe <mailto:Jonathan.Stowe@dircon.net> Analyst/Programmer, Direct Connection Connection House, 9 Selsdon Way, Cityharbour, London E14 <http://www.dircon.net>;