• SELECT CONVERT(DATETIME,'29/09/2013',103)

    Use the convert function and the date style that suits best for your operations. 🙂