Re: BUG #1332: wrong results from age function

Robert Grabowski <grabba@env.pl>

From: Robert Grabowski <grabba@env.pl>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruno Wolff III <bruno@wolff.to>, pgsql-bugs@postgresql.org
Date: 2004-12-01T15:52:52Z
Lists: pgsql-bugs
Tom Lane wrote:
> Bruno Wolff III <bruno@wolff.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=#