Re: BUG #1332: wrong results from age function
От | Robert Grabowski |
---|---|
Тема | Re: BUG #1332: wrong results from age function |
Дата | |
Msg-id | 41ADE8D4.7010903@env.pl обсуждение исходный текст |
Ответ на | Re: BUG #1332: wrong results from age function (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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=#
В списке pgsql-bugs по дате отправления: