Re: How extract time values from date fields?
Date: Fri, 15 Jan 1999 13:52:21 GMT
Message-ID: <01be408e$cbe70040$333a0dd8_at_clairema>
Hi! Maarten
Just have to use the BETWEEN
SELECT time
FROM table
where time BETWEEN 'time1' AND 'time2' ;
Good Luck
Claire M.
Maarten Meijer <M.Meijer_at_accu.uu.nl> a écrit dans l'article
<369F40E5.9D497113_at_accu.uu.nl>...
> 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 Fri Jan 15 1999 - 14:52:21 CET