>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