Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novice: select by time
Daniel -
Yes, that would certainly work. But since my mind is focused on query performance recently, wouldn't this be better, especially if there are gazillions of rows?
SELECT fields
FROM table
WHERE trunc(date_field) = date_field;
Just wonderin'... ;-)
Tom
Daniel Morgan wrote:
> 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 - 11:08:37 CDT