How to apply datetime filters
SELECT invoice_date FROM invoice WHERE invoice_date::DATE < '2021-03-06' AND invoice_date::DATE > '2021-03-01';
NOW() and INTERVAL
SELECT invoice_date, NOW()::DATE as today FROM invoice WHERE invoice_date::DATE < '2021-03-06' AND invoice_date::DATE > '2021-03-01';
SELECT invoice_date, NOW()::DATE - invoice_date::DATE AS no_of_days FROM invoice
SELECT invoice_date, invoice_date::DATE + INTERVAL '365 days' AS renewal_date FROM invoice