"Ricardo Perez Lopez" <ricpelo(at)hotmail(dot)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