Re: Server timestamp - Mailing list pgsql-general

From Craig Ringer
Subject Re: Server timestamp
Date
Msg-id 49FD9FE8.8010508@postnewspapers.com.au
Whole thread Raw
In response to Server timestamp  (Chris Bartlett <c.bartlett@paradise.net.nz>)
List 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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Server timestamp
Next
From: Justin
Date:
Subject: Re: Rounding problems