shah@lznv.UUCP (11/14/87)
It seems that INGRES (Release 5.0) has a bug in the library routines provided to handle date and time. The date and time routines are not handling localtime correctly. Specifically, the routines are off by an hour. RTI has been informed and has promised to fix the bug (did'nt say when). In the meantime, avoid using the time/date functions in EQUEL/C or SQL/C programs. Use UNIX ctime(3) instead. In REPORT, the only way to fix this, as I see it, is to set the environment variable TZ off by an hour to nullify the 'off-by-an-hour' bug. e.g. if you are in the eastern time zone, set TZ=EST6EDT before running report. Set it back to EST5EDT after that (or better yet run the report in a subshell with TZ=EST6EDT). Surprisingly, II_TIMEZONE seems to have no effect on all this. Also, it would seem logical if the bug existed when Daylight time was being observed and NOT when following the Standard time. Any pointers to alternate solutions welcome. -- Sanjeev Shah AT&T-IS Lincroft NJ USA uucp: {attmail, bellcore, ihnp4, rutgers, ulysses}!lzmi!shah voice: +1 201 576 2721