From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | system date != now() |
Date: | 2004-04-11 06:44:03 |
Message-ID: | 20040411064403.15481.qmail@web40606.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How do I update pg's date? It doesn't appear to have
been updated with DST. I was under the impression that
changing the system's date/time (date -s "...") would
cause pg to use that.
[root(at)domain data]# date
Sun Apr 11 00:39:07 MDT 2004
[root(at)domain data]#
[root(at)domain data]# psql -U admin database1
Welcome to psql 7.4.1, the PostgreSQL interactive
terminal.
database1=> select now();
now
-------------------------------
2004-04-10 23:39:14.048634-07
(1 row)
database1=> select current_time;
timetz
--------------------
23:39:46.202589-07
(1 row)
database1=> select current_date;
date
------------
2004-04-10
(1 row)
database1=> select current_timestamp;
timestamptz
------------------------------
2004-04-10 23:40:10.53221-07
(1 row)
database1=>
__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html
From | Date | Subject | |
---|---|---|---|
Next Message | CSN | 2004-04-11 07:01:42 | Re: system date != now() |
Previous Message | Greg Stark | 2004-04-11 04:52:55 | Re: running postgresql database from loopback filesystem? |