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
/>