• hi

    use like this

    select CONVERT(date, '1/1/2011',103) as date

    Regards,

    Guru