<font size=2 face="Courier New"> 1> select on_date from
my_table </font>
<br><font size=2 face="Courier New"> where date_part('hours',on_date)
= '11'</font>
<br><font size=2 face="Courier New"> or date_part('hours',on_date)
= '10'</font>
<br>
<br>
<br>
<br><font size=2 face="Courier New">+-------------------------+</font>
<br><font size=2 face="Courier New">|on_date
|</font>
<br><font size=2 face="Courier New">+-------------------------+</font>
<br><font size=2 face="Courier New">|23-jan-2002 10:46:45
|</font>
<br><font size=2 face="Courier New">|18-oct-1995 11:43:18
|</font>
<br><font size=2 face="Courier New">|26-sep-2007 11:53:46
|</font>
<br><font size=2 face="Courier New">|10-oct-2007 10:07:28
|</font>
<br><font size=2 face="Courier New">|25-oct-2007 10:59:32
|</font>
<br><font size=2 face="Courier New">|08-may-2008 11:43:46
|</font>
<br><font size=2 face="Courier New">|05-aug-2008 10:06:57
|</font>
<br><font size=2 face="Courier New">|30-jun-1994 10:06:51
|</font>
<br><font size=2 face="Courier New">|04-apr-2007 10:57:00
|</font>
<br><font size=2 face="Courier New">|29-may-2007 10:31:16
|</font>
<br><font size=2 face="Courier New">|29-may-2007 11:10:09
|</font>
<br><font size=2 face="Courier New">|26-sep-2007 11:53:27
|</font>
<br><font size=2 face="Courier New">|25-oct-2007 10:59:22
|</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Allan Biggs <Allan.Biggs@GBR.dupont.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">abc@google.com</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Cc:
</font><font size=1 face="sans-serif">info-ingres@lists.planetingres.org,
info-ingres-bounces@lists.planetingres.org</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">10/03/2016 11:37</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">Re: [Info-ingres]
Selecting rows based on time range</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">info-ingres-bounces@lists.planetingres.org</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 face="sans-serif">maybe something like <br>
select date_part('hours',on_date) from table </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
do you know </font><font size=3 color=blue><u><br>
</u></font><a href="http://www.r20.nl/TheSQLGuidetoIngres-AppendixB.pdf"><font size=2 color=blue face="sans-serif"><u>http://www.r20.nl/TheSQLGuidetoIngres-AppendixB.pdf</u></font></a><font size=3>
<br>
<br>
<br>
<br>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
From: </font><font size=1 face="sans-serif">"abc@google.com"
<abc@google.com></font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
To: </font><font size=1 face="sans-serif">info-ingres@lists.planetingres.org</font><font size=3>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
Date: </font><font size=1 face="sans-serif">10/03/2016
11:10</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Subject: </font><font size=1 face="sans-serif">[Info-ingres]
Selecting rows based on time range</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Sent by: </font><font size=1 face="sans-serif">info-ingres-bounces@lists.planetingres.org</font><font size=3>
<br>
</font>
<hr noshade><font size=3><br>
<br>
</font><tt><font size=2><br>
Hi,<br>
<br>
I want to find all rows in my database that were updated between 10:00
<br>
and 11:00 (regardless of day). I have a column called update_date
<br>
that holds the date and time of the row's last update.<br>
<br>
I'm trying something like this:<br>
<br>
select * from table<br>
where<br>
update_date-date_trunc('day',update_date) between '10:00:00'
and <br>
'11:00:00'<br>
<br>
But can't quite get it to work. Any suggestions?<br>
<br>
Thanks.<br>
<br>
_______________________________________________<br>
Info-ingres mailing list<br>
Info-ingres@lists.planetingres.org</font></tt><font size=3 color=blue><u><br>
</u></font><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres"><tt><font size=2 color=blue><u>http://lists.planetingres.org/mailman/listinfo/info-ingres</u></font></tt></a><font size=3><br>
</font>
<p><font size=3><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail
does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</font>
<p><font size=3>Francais Deutsch Italiano Espanol Portugues
Japanese Chinese Korean</font>
<p><font size=3> </font><a href=http://www.dupont.com/corp/email_disclaimer.html><font size=3>http://www.DuPont.com/corp/email_disclaimer.html</font></a><tt><font size=2>_______________________________________________<br>
Info-ingres mailing list<br>
Info-ingres@lists.planetingres.org<br>
</font></tt><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres"><tt><font size=2>http://lists.planetingres.org/mailman/listinfo/info-ingres</font></tt></a><tt><font size=2><br>
</font></tt>
<p><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>