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 '简体中文'
原文地址:https://www.cnblogs.com/xsmhero/p/2084664.html