To query the current date you can just use the following snippet:

SELECT DATE_TRUNC('month', CURRENT_DATE());
Snowflake snippet 11