BD

//SELECT DATEFORMAT( CAST ( '2018-05-09 11:22:44.741000' AS DATE ), 'Mmm Dd, yyyy' )
//SELECT CAST ( '2018-05-09 11:22:44.741000' AS DATETIME )
SELECT DATEFORMAT('2018-05-09 11:22:44.741000','YYYY-MM-DD HH:MM:SS')