Google BigQuery

Table of Contents

Standard SQL

Make sure to uncheck Use Legacy SQL

FORMATTIMESTAMP

SELECT FORMAT_TIMESTAMP("%F", TIMESTAMP "2008-12-25 15:30:00", "America/Los_Angeles") AS formatted;
+------------+
| formatted  |
+------------+
| 2008-12-25 |
+------------+