❄️
Snowflake YYYYMMDD
Output: 20260328
Quick Reference
Format String
YYYYMMDD
Output
20260328
Format Date as YYYYMMDD in Snowflake
❄️ Snowflake
SELECT TO_CHAR(CURRENT_DATE(), 'YYYYMMDD') AS formatted_date;
-- Output: 20251231Other Formats in Snowflake
YYYYMMDD in Other Languages
Official Documentation
For more information about date formatting in Snowflake, see the official documentation: