Is there any way to 'select' all record with particular date value, without specifying the time value ?
I have tried with the following command :
Select * from db1 where mydate like "12/11/1998"
but it always fails (no result return). I guess it's because I didn't use the complet date format, including the time portion.
For examples : I want to list all records with date value "1 january 98", how the sql statement should be ?