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 i
On Sun, May 3, 2009 at 7:04 AM, Chris Bartlett
wrote:
> Date and time functions like current_time return the client machine's time.
> Is there a way of getting the database server's time? I have a situation
> that requires comparison of a date stamp on records with "today", but I need
> to avoid t
Date and time functions like current_time return the client machine's
time. Is there a way of getting the database server's time? I have a
situation that requires comparison of a date stamp on records with
"today", but I need to avoid the possibility of a user changing their
computer's clock ti
