| 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: | Whole Thread | Raw Message | 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? |