SELECT tbl.createdate > '20211001' and tbl.createdate < '20211101'
I need the dates in the '' to change depending on the date the query is run. For example if I schedule it to run in November it would be SELECT tbl.createdate > '20211101' and tbls.createdate < '20211201'
and if I run it in December it would be SELECT tbl.createdate > '20211201' and tbl.createdate < '20220101'
I need the query to run without user changing the dates.
Your can use the date_trunc() function, see the manual. The result is :
SELECT *
FROM tbl
WHERE tbl.createdate > date_trunc('month', Now())
and tbl.createdate < (date_trunc('month', Now()) + interval '1 month')
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments