FORMAT_DATE

1
SELECT
2
  date,
3
  FORMAT_DATE('%Y-%m-%d', date) as iso_format,
4
  FORMAT_DATE('%d/%m/%Y', date) as us_format,
5
  FORMAT_DATE('%B %d, %Y', date) as long_format
6
FROM UNNEST([DATE '2024-01-15']) as date;

1
SELECT
2
  FORMAT_DATE('%A, %d %B %Y', CURRENT_DATE()) as full_date,
3
  FORMAT_DATE('%a, %d %b', CURRENT_DATE()) as short_date;

1
SELECT
2
  FORMAT_DATE('Report for %B %Y', report_date) as header
3
FROM `project.dataset.reports`;