From: Tom Lane <[EMAIL PROTECTED]>
To: "Ricardo Perez Lopez" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] '1 year' = '360 days' ???? Date: Sat, 23 Oct 2004 19:52:50 -0400
"Ricardo Perez Lopez" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly