SQL Server convert YY/MM/DD to proper datetime -

i have varchar in format yy/mm/dd. want convert datetime format.

how that?

just cast value:

select cast('05/01/12' date)

this work american setting sql server. if using international settings (or need international compatible), use convert().

select convert(date, '05/01/12', 11)

Copy