select '1987-01-29'::timestamp + interval '21 years' > now();Which is closer to what I wanted anyway (this was all about determining who was under 21 years old). This at least should be robust over leap years.
There is nothing simple about datetime calculations, ever :-(
-- ---- Visit http://www.not-so-obviously.com/