mysql 记录

<!-- 查询今日会员新增人数 -->
<select id="selectNewVipCountByToday" resultType="Integer">
   SELECT COUNT(Uid) 
   FROM user 
   WHERE DATE_FORMAT(VIPtimedate,'%Y-%m-%d')=DATE_SUB(curdate(),INTERVAL 0 DAY)
</select>

<!-- 查询本月总充值金额 -->
<select id="selectRechargeMonth" resultType="Double">
   SELECT SUM(rechargerecord.Rrmoney) as amount
   FROM rechargerecord 
   WHERE Rtype=1 AND rechargerecord.`Rrtime` 
   BETWEEN DATE_FORMAT( CURDATE(), '%Y-%m-01 00:00:00')
   AND DATE_FORMAT( LAST_DAY(CURDATE()), '%Y-%m-%d 23:59:59')
</select>