I am trying to create a sql query that lists vulnerabilities between 30 and 60 days ago in order to help automate our Security Program. I have tried using the following but I always get empty results:
WHERE dv.date_published between (now() - interval ‘30 days’) and (now() - interval ‘60 days’)
However, when I use the following , I get results back:
WHERE now() - date_published < INTERVAL ‘60 Days’
I have validated that there are published vulnerabilities between 30 and 60 days ago.
Does anyone have any ideas on how to go about doing this?
Thank you in advance!