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 -> Date function that leaves only the time?

Date function that leaves only the time?

From: <Mark.Wright_at_bristol.ac.uk>
Date: Mon, 8 Dec 2003 17:58:02 GMT
Message-ID: <HpL8Kq.KG1@bath.ac.uk> 





I'm looking for a function that is essectially the opposite of
TRUNC(). I.e., I have full date-time fields, but I only care about the
time. If I select TRUNC(column) I can get only records on a date, but I
want only records in a time-range (e.g. 5pm-6pm), regardless of date. How
can I do this easily?


Cheers,


Mark


-- 


Received on Mon Dec 08 2003 - 11:58:02 CST












Original text of this message













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