open_in_new
content_copy
date >= date_trunc('day', getdate() - interval '30 days') AND date < getdate()