Subject Re: Time zone offset in select
Author Adam
> >
> Surely time offset must be in the client not the server.
> Mick

Surely you can't just trust what the client says UTC should be? I have
seen installs where the clocks are out by hours because they haven't
set the right timezone. When collecting information from many
different clients, you want some standardisation (hopefully an
internet synced clock on the database server).

I could make a good case that CURRENT_UTC would be more useful than
CURRENT_TIMESTAMP. The client machines could then calculate local time
from stored time + tz offset + dst bias.