Re: How extract time values from date fields?

Hi,

Look at the date function TRUNC.
(ie TRUNC('01-jan-1999 23:15','hh24:mi') is 23:15)

E.

Maarten Meijer wrote:

> Hello Oracle programmers,
> Could anyone solve this little problem? In a PL/SQL program,
> I'm trying to
>
> select ... from ...
> where time0 between time1 and time2
>
> time0, time1 and time2 are of type DATE, but I'm only interested
> in the time portion of these dates!
> Since time0 is being input by a user, the date portion of time0
> is set to the first of the current month and year, while time1
> and time2 can have other month and year values.
> So how do I ignore these day, month and year values??
>
> Thanks!
> --
> Maarten Meijer (030)2531660/2805001 http://www.accu.nl/~mmeijer
> ACCU (Academisch Computercentrum Utrecht) fax (030)2531633
> Budapestlaan 6, P.O.Box 80011, 3508 TA Utrecht NL
Received on Sat Jan 16 1999 - 05:50:30 CET