<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Sigh. Ok, I settled on:<br>
<blockquote><tt>select '1987-01-29'::timestamp + interval '21 years'
> now();</tt><br>
</blockquote>
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.<br>
<br>
<br>
Tom Lane wrote:<br>
<blockquote cite="mid:16843(dot)1201489840(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">There is nothing simple about datetime calculations, ever :-(
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="100">--
----
Visit <a class="moz-txt-link-freetext" href="http://www.not-so-obviously.com/">http://www.not-so-obviously.com/</a>
</pre>
</body>
</html>