CODEWITHSUNDEEP
sqlpresto
urdearboy
urdearboy

Reputation: 14580

Date Between (Start & Now)

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

Upvotes: 5

Views: 93

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 175736

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;

Upvotes: 4

Related Questions