Querying date field in database?

[lowtide]

I have a date in the format mo/da/year (i.e. 3/12/2000).<br>
I would like to query a database field with datatype <br>
smalldatetime. Do I need to do some additional formatting<br>
of the date to query for all records that occur on this<br>
day? I know I can query using a format like Mar 12 2000<br>
with LIKE. But do I really have to re format the input<br>
like this?<br>
Thanks<br>
Lowtide

 

[NickBulka]

What type of database? Access, SQL Server, Oracle?<br>
<br>
-nick bulka

 

[lowtide]

Sorry about that.<br>
It's SQL Server 7.