[931] in Moira
Re: Timezones?
daemon@ATHENA.MIT.EDU (Theodore Ts'o)
Tue Oct 31 01:13:41 1995
Date: Tue, 31 Oct 1995 01:13:26 -0500
From: Theodore Ts'o <tytso@MIT.EDU>
To: John Hawkinson <jhawk@MIT.EDU>
Cc: moiradev@MIT.EDU
In-Reply-To: John Hawkinson's message of Mon, 30 Oct 1995 23:56:46 -0500,
<199510310456.XAA14990@lola-granola.MIT.EDU>
Date: Mon, 30 Oct 1995 23:56:46 -0500
From: John Hawkinson <jhawk@MIT.EDU>
Alas, alack, it was not to be. So presumably it's a function of the
server? If the moira server uses the local time, it's got a design
flaw. Someone should correct it in (hahaha) the next revision :-)
Moira stores the times internally in the database in Ingres date/time
format, so that SQL queries using date/time expressions can work.
Internally, Ingres stores the date/time using GMT, and converts to local
time when you ask it for date/times. Somewhere along the way, timezone
information isn't getting propagated correctly, or Ingres may not be
setup to deal with DST for one reason or another.
In any case, I consider this to be a minor enough nit-pick that it's not
worth wasting time to try to track down at this point. There are much
more important things for us to be worry about.
- Ted
