Compare DateTime in Oracle 8i

[camlearner]

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.

[GaryMazzone]

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.

[camlearner]

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

[GaryMazzone]

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