Re: Date function that leaves only the time?

"VC" <boston103_at_hotmail.com> wrote in message news:BUXDb.70543$8y1.268389_at_attbi_s52...
> Hello Paul,
>
> select to_char(sysdate+10/24, 'hh24:mm:ss') from dual;

Not sure how is this going to help me (or the original poster) select records where the time component of a date field is between 5pm and 6pm ?

Paul Dixon

> "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 - 08:19:16 CST