Re: How extract time values from date fields?

You can do this

Select TABLENAME from to_char(time0,'HH:MI:SS')

Maarten Meijer wrote in message <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 Mon Jan 18 1999 - 15:00:47 CET