Table of Contents

• Standard SQL
  • FORMAT_TIMESTAMP

Standard SQL

Make sure to uncheck Use Legacy SQL

FORMAT_TIMESTAMP

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

+------------+
| formatted  |
+------------+
| 2008-12-25 |
+------------+