|Subject||Re: Time zone offset in select|
> >Surely you can't just trust what the client says UTC should be? I have
> Surely time offset must be in the client not the server.
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.