摘要： 转换成varchar类型Convert(varchar,C0057_PubDate,120) like '%2010-10-09%'两个字段拼接成一个字段SELECT C0252_ID, C0252_name,C0252_Addr,((select top 1 C0003_Name from dbo.T0003_DistrictInfo where c0003_code like '%'+SUBSTRING(C0003_AreaCode,1,4)+'%')+' '+C0003_AreaName) as AreaNameFROM d 阅读全文

摘要： 参考网址：http://wenku.baidu.com/view/970c6c1655270722192ef70e.html下面是常用的几个--返回06-27-13 select CONVERT(CHAR(8), getdate(), 10)--2013-06-27 15:33:48select CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20)--2013-06-27 15:34:42.400 select CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21) --2006-02-22 select CONVERT(CHAR(10), 阅读全文