Re: Novice: select by time

Per-Arne Hellarvik wrote:

> trunc(<datetime>) should do the work....
>
> On Thu, 27 Jun 2002 16:34:09 +0200, dsmcd wrote:
>
> > Hello...
> >
> > I'd like to select all records whose time is 00:00:00 in a datetime
> > field ('MM/DD/YY HH24:MI:SS').
> >
> > Any suggestions?
> >
> > Thanks in advance,
> > D.

This will remove the time ... not select the time.

Try this instead:

SELECT fields
FROM table
WHERE TO_CHAR(date_field, 'HH:MI:SS') = '00:00:00';

Daniel Morgan Received on Thu Jun 27 2002 - 10:16:46 CDT