🔍

BigQuery Date Format YYYYMMDD

Output: 20260204

Quick Reference

Format String

%Y%m%d

Output

20260204

Format Date as YYYYMMDD in BigQuery

🔍 BigQuery

SELECT FORMAT_DATE('%Y%m%d', CURRENT_DATE()) AS formatted_date;
-- Output: 20251231

🔍 BigQuery (Parsing)

SELECT PARSE_DATE('%Y%m%d', '20251231') AS parsed_date;
-- Output: 2025-12-31

For more information about date formatting in BigQuery, see the official documentation: