Sql="select top 10 artid,arttitle,cast(year(builddate) as nvarchar(4))+'-'+cast(month(builddate) as nvarchar(2))+'-'+cast(day(builddate) as nvarchar(2)), hits from pub_article where arttype="&TempArray(0,i)&" and boardid="&PUB_GFGS_ID&" order by builddate desc"
帮我解释一哈代码

cast(year(builddate) as nvarchar(4))+'-'+cast(month(builddate) as nvarchar(2))+'-'+cast(day(builddate) as nvarchar(2)),
这一点就行了啊

程序用的是什么数据库？

应该就是builddate里的 年-月-日
其中年4个字符
月日都是2个字符....
我也不太明...不过大概是这个意思了

这是MYSQL数据库吧？

你另外还有2个函数吧？