Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Quering a specific TIME not date

Re: Quering a specific TIME not date

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 26 Jan 2007 15:41:58 +0100
Message-ID: <51ui99F1macebU2@mid.individual.net> 





On 26.01.2007 14:05, Gaz wrote:


> doesn't work for greater than :(




You said



> How would i write a SQL statement to find me all records that have

> 10:00 in them and ignore the date?




To me that sounds more like "at 10:00" and not "at or after 10:00". 
Anyway...



Kind regards



        robert
Received on Fri Jan 26 2007 - 08:41:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US