system date != now()

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

Browse pgsql-general by date

  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?