SLTechnology News&Howtos › Database ›

Query all-day data

Shulou Source: shulou.com Published: 2022-06-01 10:24:08 10月03日 Update

Query all the data for the day

SELECT FROM table name WHERE DATEDIFF (field, NOW ()) = 0

Query all the data from yesterday

SELECT FROM table name WHERE DATEDIFF (field, NOW ()) =-1

Tags: Data queries fields all day Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Shulou Information macOS MariaDB MySQL