从NOW()-1天选择记录 [英] Select records from NOW() -1 Day

问题描述

MySQL语句中是否有一种方法可以通过> = NOW()-1对记录进行排序(通过日期戳)，以便选择从前一天到将来的所有记录?

Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so all records from the day before today to the future are selected?

推荐答案

根据

Judging by the documentation for date/time functions, you should be able to do something like:

SELECT * FROM FOO
WHERE MY_DATE_FIELD >= NOW() - INTERVAL 1 DAY

这篇关于从NOW()-1天选择记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！