select left( CONVERT(VARCHAR(20) , GETDATE()),3)+'.'+ CAST(YEAR(GETDATE()) as CHAR(4))
查询结果如下:
SET language 'english'
select left( CONVERT(VARCHAR(20) , GETDATE()),3)+'.'+ CAST(YEAR(GETDATE()) as CHAR(4))
查询结果如下:
SQL 查询月份英语简称/简写为大写则如下:
SET language 'english'
select upper( left( CONVERT(VARCHAR(20) , GETDATE()),3))+'.'+ CAST(YEAR(GETDATE()) as CHAR(4))