Re: system date != now() - Mailing list pgsql-general

From CSN
Subject Re: system date != now()
Date
Msg-id 20040411070142.18533.qmail@web40605.mail.yahoo.com
Whole thread Raw
In response to system date != now()  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: system date != now()
List pgsql-general
timezone in postgresql.conf was set to MST. Setting it
to MDT gave this error:

LOG:  unrecognized time zone name: "MDT"
FATAL:  invalid value for parameter "timezone": "MDT"

http://www.postgresql.org/docs/7.4/interactive/datetime-keywords.html#DATETIME-TIMEZONE-TABLE
(MDT is listed there)

Anyhow, I commented out "timezone" and the time is
correct now.


--- CSN <cool_screen_name90001@yahoo.com> wrote:
> 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@domain data]# date
> Sun Apr 11 00:39:07 MDT 2004
> [root@domain data]#
> [root@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
>


__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html

pgsql-general by date:

Previous
From: CSN
Date:
Subject: system date != now()
Next
From: Hitesh Bagadiya
Date:
Subject: Re: Sorting in Unicode not working