<div>查询当天数据：</div>
<div>$sql = "SELECT id,apmac,devmac,rssi,createtime from sm_rssi WHERE date_format(from_UNIXTIME(createtime),'%Y-%m-%d') = DATE_FORMAT(now(),'%Y-%m-%d')";</div>
<div></div>
<div>查询一周的数据：</div>
<div>$sql = "SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` WHERE kid_id=$value and YEARWEEK(FROM_UNIXTIME(cost_end_time)) = YEARWEEK(now())";//某个用户一周的数据</div>
<div></div>
<div></div>
<div>//按第周七天分组显示数据</div>
<div>SELECT kid_name,kid_id,date_format(FROM_UNIXTIME(cost_end_time),'%Y-%m-%d') as createtime, sum(cost_value_cost) as total</div>
<div>FROM `vi_caloric_info`</div>
<div>where kid_id=19</div>
<div>and date_format(FROM_UNIXTIME(cost_end_time),'%Y-%m-%d')&gt;=date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 1 DAY)</div>
<div>and YEARWEEK(FROM_UNIXTIME(cost_end_time)) = YEARWEEK(now())</div>
<div>GROUP BY createtime;</div>
<div></div>
<div></div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` WHERE kid_id=10</div>
<div></div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` WHERE</div>
<div>YEARWEEK(date_format(cost_end_time,'%Y-%m-%d')) = YEARWEEK(now()) ;</div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` WHERE</div>
<div></div>
<div>SELECT YEARWEEK(NOW())</div>
<div></div>
<div>SELECT NOW()</div>
<div></div>
<div>SELECT date(FROM_UNIXTIME(1471858545)</div>
<div></div>
<div>SELECT date_format(FROM_UNIXTIME(1471858545),'%Y-%m-%d');</div>
<div></div>
<div>SELECT YEARWEEK(FROM_UNIXTIME(1471858545))</div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` GROUP BY cost_kid_id;</div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` where TO_DAYS(cost_end_time)= TO_DAYS((now()));</div>
<div></div>
<div>SELECT UNIX_TIMESTAMP(time());</div>
<div></div>
<div>SELECT UNIXTIME</div>
<div></div>
<div></div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` WHERE kid_id=10 and YEARWEEK(FROM_UNIXTIME(cost_end_time)) = YEARWEEK(now())</div>
<div></div>
<div>SELECT</div>
<div></div>
<div>select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 1 DAY)</div>
<div></div>
<div>SELECT WEEKDAY(curdate()) + 1 DAY</div>
<div></div>
<div>SELECT kid_name,kid_id,date_format(FROM_UNIXTIME(cost_end_time),'%Y-%m-%d') as createtime, sum(cost_value_cost) as total</div>
<div>FROM `vi_caloric_info`</div>
<div>where kid_id=11</div>
<div>and date_format(FROM_UNIXTIME(cost_end_time),'%Y-%m-%d')&gt;=DATE_ADD(curdate(),interval -day(curdate())+1 day)</div>
<div>and YEARWEEK(FROM_UNIXTIME(cost_end_time)) = YEARWEEK(now())</div>
<div>GROUP BY createtime;</div>
<div></div>
<div>SELECT *, sum(cost_value_cost) as total FROM `vi_caloric_info` where GROUP BY kid_id;</div>
<div></div>
<div>select dayofweek(2016-08-24);</div>
<div></div>
<div></div>
<div>select DATE_ADD(curdate(),interval -day(curdate())+1 day);</div>
<div></div>