From: | Robert Grabowski <grabba(at)env(dot)pl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1332: wrong results from age function |
Date: | 2004-12-01 15:52:52 |
Message-ID: | 41ADE8D4.7010903@env.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Tom Lane wrote:
> Bruno Wolff III <bruno(at)wolff(dot)to> writes:
>
>>>I think, it should be "1 mon".
>
>
>>I get "1 mon" when I try this:
>
>
> So do I. It might be timezone dependent though ... Robert, what
> timezone setting are you using?
>
> regards, tom lane
>
>
Hi!
It is some informactions from my PostgreSQL instalaction. Can it help
you?
Robert
$ psql -U root -d tmpl
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
tmpl=# select version();
version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3
20040412 (Gentoo Linux 3.3.3-r6, ssp-3.3.2-2, pie-8.7.6)
(1 row)
tmpl=# show TimeZone;
TimeZone
----------
unknown
(1 row)
tmpl=# select now();
now
-------------------------------
2004-12-01 16:47:46.522403+01
(1 row)
tmpl=# show DateStyle;
DateStyle
-----------
ISO, MDY
(1 row)
tmpl=# show lc_time;
lc_time
---------
C
(1 row)
tmpl=# show australian_timezones;
australian_timezones
----------------------
off
(1 row)
tmpl=#
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-12-01 15:54:29 | Re: BUG #1335: Wrong sort result in union queries |
Previous Message | Tom Lane | 2004-12-01 15:28:58 | Re: BUG #1332: wrong results from age function |