Server timestamp

From: Chris Bartlett <c(dot)bartlett(at)paradise(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Server timestamp
Date: 2009-05-03 13:04:36
Message-ID: p06240806c623455b2ba1@[192.168.200.4]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 time.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-05-03 13:41:33 Re: Server timestamp
Previous Message Dave Page 2009-05-03 12:58:01 Re: windows service