select convert(datetime,'20060530',120)
/*
------------------------------------------------------
2006-05-30 00:00:00.000
*/
/*
------------------------------------------------------
2006-05-30 00:00:00.000
*/
2006-05-30 00:00:00.000