SQL 日期中英文转换显示
set language english
select convert(datetime,'10/dec/2009 12:22:31.120') from openrowset( 'SQLOLEDB ', '10.10.80.83'; 'sa'; 'Password#1',creditzj.dbo.X1)
set language '简体中文'
select convert(datetime,'10/dec/2009 12:22:31.120') from openrowset( 'SQLOLEDB ', '10.10.80.83'; 'sa'; 'Password#1',creditzj.dbo.X1)
set language '简体中文'
