Google BigQuery: Convert Date Time to YYYYMMDD format

The below syntax helps to convert date time format to date format using Google BigQuery:

SELECT
<date_time column> DATETIME, STRFTIME_UTC_USEC(<date_time column>,'%Y%m%d')
as DATE
FROM <table>