Re: Date function that leaves only the time?

Mark.Wright_at_bristol.ac.uk wrote:

>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

Look at the TO_CHAR function's date format masks in the docs..

Hint('HH24:MI:SS') Received on Mon Dec 08 2003 - 12:41:42 CST