Re: Date function that leaves only the time?

SELECT DATE_COL
FROM TABLE
WHERE TO_CHAR( date_col, 'SSSSS') BETWEEN 61200 AND 64000

or

SELECT DATE_COL
FROM TABLE
WHERE TO_NUMBER(TO_CHAR( date_col, 'SSSSS')) BETWEEN ((17*60)*60) AND ((18*60)*60)

I think to_number will make it run faster...

"Paul Dixon" <root_at_127.0.0.1> wrote in message news:brpb6p$mvf$1_at_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 - 06:26:23 CST