I need to know if there is a way to get month as string from bigquery.
select Month(timestamp(ARRIVAL_TIME_PAC_TZ)) from xyz
It displays Month as 1,2,... i want it to display as Jan, Feb.
I tried using to_Char but Bigquery doesn't support it, saying to_char not recognized.
Thanks in advance!