Thread: About intervals

Hi all.<br /> I have a table with some timestamps fields. For example this table:<br /><br /><b>             
date1       |         date2        <br /> -----------------------------+---------------------------<br />  2004-03-01
11:20:00| 2004-03-01 11:55:00</b><br /><br /> If I do a query like this, I get:<br /><br /><i> SELECT date2 - date1 as
diffFROM table</i>;<br /><b> diff  <br /> -------<br />  00:35<br /> (1 row)<br /></b><br /><br />  but if I do a query
likethis, I get:<br /><i> SELECT date2 - date1 as diff FROM table WHERE date2 - date1 >= interval '15:00';</i><br
/><b> diff<br /> ------<br /> (0 rows)<br /></b><br /> What can I do to do a query like the previous one , and get the
rightanswer??<br /><br /> Thanks !!<br /><div class="moz-signature">-- <br /></div><span style="font-weight:
bold;">==                                ==<br />    Pablo A. Velasquez Rivas<br /> Computer Science Engineer<br />
==                                ==<br /></span><i> All programmers are optimists </i> -- Frederick P. Brooks, Jr.<br
/>

On Fri, May 28, 2004 at 12:27:53 -0600, Pablo Velasquez Rivas <pvelasquez@its.co.cr> wrote:
> 
> but if I do a query like this, I get:
> / SELECT date2 - date1 as diff FROM table WHERE date2 - date1 >= 
> interval '15:00';/
> * diff
> ------
> (0 rows)
> *
> What can I do to do a query like the previous one , and get the right 
> answer??

It looks like 15:00 is being taking to mean 15 hours 0 minutes.
The more normal syntax for specifying 15 minutes is '15 minutes.
So you probably want:
SELECT date2 - date1 as diff FROM table WHERE date2 - date1 >= interval
'15 minutes';