>>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
>>where convert(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 ?
>>

>
>
>

>-- Is not affected by SET DATEFORMAT
>where MyDateTimeColumn >= '2012-10-01'
>

Thanks Sergey