Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: extract or date_part on an interval? How many e
- From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Re: extract or date_part on an interval? How many e
- Date: Sun, 27 Jan 2008 20:51:32 -0800
- Message-id: <479D5F54.3040107@obviously.com> <text/plain>
<!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>
- Follow-Ups:
- Re: extract or date_part on an interval? How many e
- From: Michael Glaesemann
- Re: extract or date_part on an interval? How many e
- References:
- extract or date_part on an interval? How many e
- From: Bryce Nesbitt
- Re: extract or date_part on an interval? How many e
- From: Tom Lane
- extract or date_part on an interval? How many e
- Prev by Date: Re: extract or date_part on an interval? How many e
- Next by Date: Re: extract or date_part on an interval? How many e
- Previous by thread: Re: extract or date_part on an interval? How many e
- Next by thread: Re: extract or date_part on an interval? How many e
- Indexes: