| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novice: select by time
On Thu, 27 Jun 2002 14:34:09 GMT, dsmcd <dsmcd_at_uswestmail.net> 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').
select *
from mytable
where mydate = trunc(mydate);
Received on Thu Jun 27 2002 - 10:26:16 CDT
 |
 |