Easy Date Searching Question

ORACLE and Date Searching. What is the best way to search in SQL ignoring the time portion of the date.

Example:

Table Emp:
Ename char(100)
InDate date

Find all employees added 12/23/92 (any time of day).

select Ename
 from Emp
where InDate = '23-DEC-92';

Will fail?

Thanks.

-- 


| Matteo diTommaso  (ditommm_at_aa.wl.com) |       /|                            |

| Ann Arbor, MI, USA                    |   \'o.O'      This space for rent.  |

| Phone: (313) 996-7148                 |   =(___)=                           |


| (Full disclaimer available by e-mail) |       U  ACK! THPTPHH!              |