Michel Gauthier ([log in to unmask]) wrote:
: We've been facing that problem last year for an already existing application
: for which none of the timezone concerns were anticipated when we built it.

: However I had a few reflections on the topic and I concluded that storing
: date/time is not enough and Timezone (or offset) should be stored too.
: I'd be glad to know how you will deal with this
: Michel Gauthier

If you store only the UTC time then you can then display this based on
each user's TZ variable.

You need to be careful here getting the time because one way or the other
is expensive.  I.e. on HP-UX calling time(2) is cheap.  Converting it to
local or GMT (really UTC) is expensive.

So compute the timezone difference once and then use the cheapest way to get
the time.