public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Curt Sampson <[email protected]>
Cc: [email protected]
Subject: Re: 6.8.5: Location of CURRENT_DATE unclear
Date: Fri, 11 Apr 2003 16:34:14 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Curt Sampson <[email protected]> writes:
> In table 6-18 the 7.3 documentation, it describes the CURRENT_DATE
> function as returning "today's date." Section 6.8.4 mentions
> CURRENT_DATE again, but does not describe what location is used to
> determine the current date. Does this return the current date as of now,
> UTC, or the current date in the local timezone?
The latter, as you could easily have found by experiment.
regression=# show timezone;
TimeZone
----------
EST5EDT
(1 row)
regression=# select now(), current_date;
now | date
------------------------------+------------
2003-04-11 16:32:59.84755-04 | 2003-04-11
(1 row)
regression=# set timezone to 'JST-9';
SET
regression=# select now(), current_date;
now | date
-------------------------------+------------
2003-04-12 05:33:19.119802+09 | 2003-04-12
(1 row)
regards, tom lane
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: 6.8.5: Location of CURRENT_DATE unclear
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox