热门标签
更多>
搜索结果
查询Tags标签： YEARWEEK，共有 2条记录-
mysql查询本周的记录
select * from circle_order where draw_id = #{drawId} and trading_id = #{tradingId} and user_id = #{userId} and YEARWEEK(DATE_FORMAT(FROM_UNIXTIME(pay_time),%Y-%m-%d)) = YEARWEEK(NOW())")pay_time是要查询时间的字段
2021/9/24 19:12:24 人评论 次浏览 -
mysql查询本周的记录
select * from circle_order where draw_id = #{drawId} and trading_id = #{tradingId} and user_id = #{userId} and YEARWEEK(DATE_FORMAT(FROM_UNIXTIME(pay_time),%Y-%m-%d)) = YEARWEEK(NOW())")pay_time是要查询时间的字段
2021/9/24 19:12:24 人评论 次浏览
