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 -> Compare time part of date field

Compare time part of date field

From: Jens Riedel <JensRie_at_gmx.de>
Date: Wed, 14 Apr 2004 14:24:54 +0200
Message-ID: <c5jahv$2dqob$1@ID-67571.news.uni-berlin.de> 





Hello NG,



I have a table with a field "STARTDATE" which is a DATE field.
Now I'd like to create a SELECT statement which returns all rows where 
the STARTDATE contains the time 05:59:59, no matter which day.



How can I do this the best way?



Thanx for help,


Jens
Received on Wed Apr 14 2004 - 07:24:54 CDT












Original text of this message













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