Re: '1 year' = '360 days' ????

>From: Tom Lane <tgl@sss.pgh.pa.us>
>To: "Ricardo Perez Lopez" <ricpelo@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] '1 year' = '360 days' ???? Date: Sat, 23 Oct 2004
>19:52:50 -0400
>
>"Ricardo Perez Lopez" <ricpelo@hotmail.com> writes:
> > I have observed that, for PostgreSQL, one year is actually 360 days:
>
> > SELECT '1 year'::timestamp = '360 days'::timestamp;
>
> > ?column?
> > -------------
> >     t
>
>Nonsense.
>
>regression=# SELECT '1 year'::timestamp = '360 days'::timestamp;
>ERROR:  invalid input syntax for type timestamp: "1 year"
>
>How about telling us what you *really* did, instead of posting faked
>examples?

Sorry: it's an errata. The query is, actually:

SELECT '1 year'::interval = '360 days'::interval;

Sorry about the inconvenience.

>There are some contexts in which an interval (not a timestamp) of 1
>month will be taken as equivalent to 30 days, for lack of any better
>idea, but it's not the case that Postgres doesn't know the difference.
>
>            regards, tom lane

Thanks.

_________________________________________________________________
Acepta el reto MSN Premium: Protección para tus hijos en internet.
Descárgalo y pruébalo 2 meses gratis.
http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil