Reformat Dates In BigQuery (E.g. "YYYY-MM-DD" to "DD-MM-YYYY")

Reformat Dates In BigQuery (E.g. "YYYY-MM-DD" to "DD-MM-YYYY")
SELECT FORMAT_DATE('%D-%M-%Y', Contract_Start_Date) as Contract_Start_Date_Transformed
FROM `(ProjectName).(DatasetName).Contracts`
#bigquery
#dates
#SQL

[@sherythomas7661]

The date data type gets changed to string data type

[@fatemehsamimi2205]

Thanks for the video

[@realmehranvahedi]

Hello Fatemeh. Thank you so much for the comment. I'm happy that the video was useful. I invite you to watch all my videos and don't forget to subscribe and share.