How to convert DD-MMM-YY to YYYY/MM/DD in Big Query SQL

user_17310874 0
Viewed 1033

I've one date format as DD-MMM-YY in one of my Big Query table as a STRING column (e.g 31-OCT-20). Now I need to convert the format to YYYY/MM/DD in Date format to insert data to another table (e.g 2020/10/31).

Please help with the required format for Google Big Query.

Thanks in advance.

google-bigquery date-formatting
2 Answers

It worked after trying a combination of PARSE_DATE and FORMAT_DATE:

SELECT FORMAT_DATE("%Y/%m/%d",PARSE_DATE('%d-%b-%y','31-OCT-20'))
user_173108740

Use PARSE_DATE:

SELECT PARSE_DATE('%d-%b-%y','31-OCT-20')
user_134735250
Related