文、意如
查詢日期區間
例:2023年7、8月資料
SELECT * FROM grade WHERE create_time >= '2023-07-01' AND create_time <= '2023-08-31';
使用介於BETWEEN
SELECT * FROM grade WHERE create_time BETWEEN '2023-07-01' AND '2023-08-31';
查詢加上時間
SELECT * FROM grade WHERE update_time >= '2023-07-01' AND update_time <= '2023-08-12 09:00:00';
Yiru@Studio - 關於我 - 意如