SELECT MOD(UNIX_TIMESTAMP(NOW())+28800,86400),UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(DATE(NOW()))
=====================
求当前时间与当天零点的秒差。
SELECT MOD(UNIX_TIMESTAMP(NOW())+28800,86400),UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(DATE(NOW()))
=====================
求当前时间与当天零点的秒差。