sql 语句 统计求教

Question

<?php $sql="SELECT COUNT(*) AS count FROM dc_content WHERE updatetime between time()-(date(h)*60*60+date(i)*60+date(s)) and time()-(date(h)*60*60+date(i)*60+date(s))+24*60*60";
                            $query=mysql_query($sql);
                          if($rs=mysql_fetch_array($query)){
                          $count=$rs[0];
                          }else{
                         $count=0;
                       }
                     echo $count;
 ?>是想查询  今天更新的数据  有多少条  但是数据库中 updatetime 为时间戳   ！ 

Answer 1

mysql的FROM_UNIXTIME( )函数可以将时间戳转化为日期然后加上now()函数，就可以了

Answer 2

SELECT COUNT(*) AS count FROM dc_content WHERE updatetime between UNIX_TIMESTAMP(curdate()) and UNIX_TIMESTAMP(curdate())+24*60*60-1