Convert "Month `YY" string format to date in Bigquery standard SQL

Nata Published at Dev

Nata

I have dates in the database in the following format stored as strings "April `20". I need to convert them to dates as I need to perform some calcualtioin (i.e. +12 month to a certain date). I tried CAST date as DATE but that does work and I see why. PARSE_DATE didn't work either. Yet not sure what could work. Hope someones has suggestions, much appreciated!

Nata

Alright, it was the PARSE_DATE function. And the solution in this case is

Parse_DATE('%B `%y', date)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2022-11-1

Comments

0 comments

Prev: I'm trying to position the image card to overlay the card top border using "bootstrap", need help . or I can do it only with CSS?

Convert a non-standard format string to a date

Convert string in HH:MM:SS format to seconds in Google BigQuery (Standard SQL)

Convert to date format error: character string is not in a standard unambiguous format

Convert string date to date format in pyspark SQL

Pivot with Month-YY format

BigQuery convert String to Date

Convert "Month `YY" string format to date in Bigquery standard SQL

Convert "Month `YY" string format to date in Bigquery standard SQL

pump.io port in URL

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Using Response.Redirect with Friendly URLS in ASP.NET

Can a 32-bit antivirus program protect you from 64-bit threats

Double spacing in rmarkdown pdf

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

3D Touch Peek Swipe Like Mail

Bootstrap 5 Static Modal Still Closes when I Click Outside

Assembly definition can't resolve namespaces from external packages

Vector input in shiny R and then use it

Emulator wrong screen resolution in Android Studio 1.3

Svchost high CPU from Microsoft.BingWeather app errors

Graphics Context misaligned on first paint

Python connect to firebird docker database

Is this docker-for-mac password dialog legit?

How to save models trained locally in Amazon SageMaker?