I want to look for all records within a table that has date column for a specific date, at the moment I am trying this query,

```
SELECT     *
FROM      Table_ABC
WHERE     DateCreated CONTAINS 24/10/2012

```

But its not working