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

"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?

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