sql - 日期之间(开始和现在)

Question

不知道如何使用 NOW()快速运行。似乎应该是直截了当的，但我没有运气

SELECT DISTINCT field
FROM table
WHERE field BETWEEN '2019-01-01' and NOW()

字段 = varchar

Answer 1

您应该匹配数据类型以避免隐式转换:

SELECT DISTINCT field
FROM table
WHERE CAST(field AS DATE) BETWEEN DATE '2019-01-01' AND CURRENT_DATE;

SELECT DISTINCT field
FROM table
WHERE DATE(field) BETWEEN DATE '2019-01-01' AND CURRENT_DATE;