Обсуждение: month abreviation
Hi, I got this answer in my version -------------------------------------------------------------------------------------------------------------------PostgreSQL 8.3develon i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) (1 row) note the month abreviation (mons?) is this intentional? sgerp=# select age(current_date, '1979-08-15'::date); age -------------------------27 years 10 mons 5 days (1 row) -- Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook
Jaime Casanova wrote: > note the month abreviation (mons?) is this intentional? > This notation has been used since the code was written (~7 years ago) [1]. [1] http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c?rev=1.42;content-type=text%2Fx-cvsweb-markup -- Euler Taveira de Oliveira http://www.timbira.com/
On 6/22/07, Euler Taveira de Oliveira <euler@timbira.com> wrote: > Jaime Casanova wrote: > > > note the month abreviation (mons?) is this intentional? > > > This notation has been used since the code was written (~7 years ago) [1]. > > [1] > http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c?rev=1.42;content-type=text%2Fx-cvsweb-markup > mmm... so, it had been bad for 7 years now... ;) ok, acceptting that as an abreviattion for months, what controls that. why u get "years", "days" and "mons", i mean, why is this one abreviated when the other two are not -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook
Jaime Casanova wrote: > On 6/22/07, Euler Taveira de Oliveira <euler@timbira.com> wrote: > > Jaime Casanova wrote: > > > > > note the month abreviation (mons?) is this intentional? > > > > > This notation has been used since the code was written (~7 years ago) [1]. > > > > [1] > > http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c?rev=1.42;content-type=text%2Fx-cvsweb-markup > > > > mmm... so, it had been bad for 7 years now... ;) > ok, acceptting that as an abreviattion for months, what controls that. > why u get "years", "days" and "mons", i mean, why is this one > abreviated when the other two are not I thought there was some standard that required that, but I don't remember which one. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +