>Hi all, I have a table containing a DateTime column, how can I retrieve all records on or after a date such as 01/10/2012 ? I've tried >
>
> Select *
>from mytable
>whereconvert(varchar,MyDateTimeColumn,3) >= '01/10/12' but I'm still getting records with a date prior to that e.g I get records back with'23/07/12' - any ideas ?
>