Compare DateTime in Oracle 8i

I have a table that store datetime(example: StartDate) that store the date and time. Now i have a form in vb6 that search the startdate by searching only date.
example: startdate in table(12/01/2007 11:00:00 AM)
I want to search 12/01/2007.

I mean that it search only date(not include time). How to do that? Thanks.

You will need to format the datetime on the server to date only and then format the seach as a date using Oracle To_Date function.

How can I format the datetime on the server to date only? Thanks.

To_Date(To_String(fieldname,'mm/dd/yyyy'),'mm/dd/yyyy)