select convert(smalldatetime, 'Jul 6 2005 12:00:00:000AM') 前面可能要设一个日期的 set language 设成是英文的
SET LANGUAGE us_english select convert(smalldatetime, 'Jul 6 2005 12:00:00:000AM')
SET LANGUAGE us_english select convert(datetime, 'Jul 6 2005 12:00:00:000AM')
set language us_english select convert (datetime ,'Jul 6 2005 12:00:00:000AM') 或 set language us_english select cast('Jul 6 2005 12:00:00:000AM' as datetime)
前面可能要设一个日期的 set language 设成是英文的
select convert(smalldatetime, 'Jul 6 2005 12:00:00:000AM')
select convert(datetime, 'Jul 6 2005 12:00:00:000AM')
select convert (datetime ,'Jul 6 2005 12:00:00:000AM')
或
set language us_english
select cast('Jul 6 2005 12:00:00:000AM' as datetime)