How do I cast a timestamp column as a MM/DD/YYYY in BigQuery-CodePudding

Home > Software engineering > How do I cast a timestamp column as a MM/DD/YYYY in BigQuery

How do I cast a timestamp column as a MM/DD/YYYY in BigQuery

Time：08-24

I'm trying to cast the results of an entire column in BigQuery in MM/DD/YYYY format

Time_Column
2022-05-26T17:32:41.000Z
2022-05-28T06:34:23.000Z

Results:

CodePudding user response：

We can try to use FORMAT_DATE function to make it, we can refer to this link Supported Format Elements For DATE to use your expected date format from the datetime type.

SELECT FORMAT_DATE("%m/%d/%Y", Time_Column) 
FROM T