In Snowflake, how do I get data before current month?
Below is what I tried and the query errors out. Order date is in this format: ‘YYYY-MM-DD’
SELECT
OrderDate,
OrderNumber,
Customer
FROM
OrderHistory
WHERE
OrderDate < MONTH(GETDATE())
New contributor
HoosierDuckling is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.