Mysql获取当前系统时间前三十分钟数据
SELECT `u_id` uId,`u_scores` uScores,MAX(`u_scores_time`) uScoresTime ,`u_scores2` uScores2,`u_scores2_time` uScores2Time,`u_iss_type` uIssType FROM f_risk_result WHERE u_scores_time>DATE_ADD(N
·
SELECT `u_id` uId,`u_scores` uScores,MAX(`u_scores_time`) uScoresTime ,`u_scores2` uScores2,`u_scores2_time` uScores2Time,`u_iss_type` uIssType FROM f_risk_result WHERE u_scores_time>DATE_ADD(NOW(), INTERVAL -30 MINUTE) AND u_iss_type in(4,5);
SELECT * FROM 表名 WHERE 字段名 > DATE_ADD(NOW(), INTERVAL -30 MINUTE) ;
更多推荐
已为社区贡献1条内容
所有评论(0)