Re: Date function that leaves only the time?

From: Paul Dixon <root_at_127.0.0.1>
Date: Wed, 17 Dec 2003 10:29:45 +0000 (UTC)
Message-ID: <brpb6p$mvf$1@visp.bt.co.uk>

<Mark.Wright_at_bristol.ac.uk> wrote in message news:HpL8Kq.KG1_at_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,

I would do this by using following selection criteria :-

WHERE date_column - TRUNC(date_coulmn) BETWEEN 17/24 and 18/24

but would be very interested in finding any better ways.

Paul Dixon Received on Wed Dec 17 2003 - 04:29:45 CST