按日期统计 某天 发贴最多多少条
select top 1 count(*) as max from bbs group by convert(varchar(10),realeasedate,120) order by max desc
当天发了多少条
String date=DateUtil.convertStrToTimestamp(new Date()).toString().substring(0,10);
String sql="select count(bbsid) from bbs where convert(varchar(21),realeasedate,120) like '"+date+"%'";
posted on 2009-04-10 16:52
Crying 阅读(147)
评论(0) 编辑 收藏 所属分类:
数据库