Hi! I'm having trouble in querying my tables. I have the ff. syntax:

Select * from mytable where mydatecolumn='08/10/1999'

It returns no rows though the table is not empty. How do I fix this so that I get all the records regardless of what time during the day they were saved. Thanks for all the help!

Carlos