Snowflake snippets
Current date in Snwoflake
To query the current date you can just use the following snippet:
SELECT DATE_TRUNC('month', CURRENT_DATE());
Nicola Simboli Senior Analytics Engineer
15+ years across SaaS, enterprise and consulting. Focused on scalable data platforms, metric reliability and analytics systems that teams actually use.