Re: Server timestamp

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Chris Bartlett <c(dot)bartlett(at)paradise(dot)net(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Server timestamp
Date: 2009-05-03 13:45:12
Message-ID: 49FD9FE8.8010508@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Bartlett wrote:
> Date and time functions like current_time return the client machine's
> time.

Er, no they don't. They return the server's time, adjusted to the
client's time zone if the client specified its time zone using SET TIMEZONE.

At least, that's how they behave here, and I can't imagine any sane
client interface attempting to change it.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2009-05-03 14:42:13 Re: Rounding problems
Previous Message Scott Marlowe 2009-05-03 13:41:33 Re: Server timestamp