Date Between (Start & Now)

Question

Not sure how to use the NOW() function in presto. Seems like it should be straight forward, but i'm getting no luck

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

field = varchar

Answer 1

You should match data types to avoid implicit conversions:

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;