>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
It's been a while, but try
SELECT * from mytable where CONVERT( C(10),mydatecolumn,101)='08/10/1999'
this gives date in mm/dd/yyyy format