Re: Compare time part of date field

On Wed, 14 Apr 2004 14:24:54 +0200, Jens Riedel <JensRie_at_gmx.de> wrote:

>Hello NG,
>
>I have a table with a field "STARTDATE" which is a DATE field.
>Now I'd like to create a SELECT statement which returns all rows where
>the STARTDATE contains the time 05:59:59, no matter which day.
>
>How can I do this the best way?
>
>Thanx for help,
>Jens

Look up the to_char function in your documentation.

--
Sybrand Bakker, Senior Oracle DBA