🔍
BigQuery Date Format DD/MM/YYYY
Output: 15/01/2025
Quick Reference
Format String
%d/%m/%Y
Output
15/01/2025
Format Date as DD/MM/YYYY in BigQuery
🔍 BigQuery
SELECT FORMAT_DATE('%d/%m/%Y', CURRENT_DATE()) AS formatted_date;
-- Output: 31/12/2025Other Formats in BigQuery
DD/MM/YYYY in Other Languages
Official Documentation
For more information about date formatting in BigQuery, see the official documentation: