我这里没有问题哦:
select CAST('Feb 19 1952 12:00AM' AS datetime)
/*
------------------------------------------------------
1952-02-19 00:00:00.000(1 row(s) affected)
*/
select CAST('Feb 19 1952 12:00AM' AS datetime)
/*
------------------------------------------------------
1952-02-19 00:00:00.000(1 row(s) affected)
*/
select convert(datetime,'Feb 19 1952 12:00AM',120)
/*
Language ID
-----------
0 --表示是english,不明白他代表的语言,可以用sp_helplanguage察看各种语言的资讯(1 row(s) affected)
*/
SET LANGUAGE 'Traditional Chinese' --改变语言环境为繁体中文
/*
Changed language setting to 繁體中文.
*/select CAST('Feb 19 1952 12:00AM' AS datetime)/*
Server: Msg 241, Level 16, State 1, Line 1
Syntax error converting datetime from character string.
*/
哦,就和搂主的错误一样,呵呵!SET LANGUAGE 'English' --还原我的语言环境:
/*
Changed language setting to us_english.
*/
select CAST('Feb 19 1952 12:00AM' AS datetime)/*
------------------------------------------------------
1952-02-19 00:00:00.000(1 row(s) affected)*/