摘要:
select Title,datepart(year,DateCreated) from CMS_Content 只取年只显示年月,不显示日:select datepart(year,getdate())*100+datepart(month,getdate()) 200811年月日格式化select CONVERT(varchar, getdate(), 120 )2004-09-12 11:06:08select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),\'-\',\'\'),\ 阅读全文