"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? 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html