SQL Server:SET LANGUAGE 'English'
SELECT GETDATE(),CONVERT(VARCHAR,GETDATE(),107)
Oracle:select to_char(to_date('2009-07-20','yyyy-mm-dd'),'dd-Month -yyyy','NLS_DATE_LANGUAGE = American') from dual;
当出现无效的月份信息时,alter session set nls_date_language='american';