STRING to DATE in BIGQUERY

string date google-bigquery
Lucasaudati11 picture Lucasaudati11 · Jun 15, 2017 · Viewed 49.7k times · Source

I am struggling trying to do this with Google BigQuery:

I do have a column with dates in this following STRING format:

6/9/2017   (M/D/YYYY)

I am wondering how can I deal with this, trying to use then the DATE clause., in order to get the DATE format:

YYYY-MM-DD.

Thanks in advance.

Answer

Felipe Hoffa picture Felipe Hoffa · Jun 15, 2017

Easy one, with standard SQL:

#standardSQL
SELECT PARSE_DATE('%m/%d/%Y',  '6/22/2017')


2017-06-22

https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#supported-format-elements-for-date

Related questions

Java string to date conversion

What is the best way to convert a String in the format 'January 2, 2010' to a Date in Java? Ultimately, I want to break out the month, the day, and the year as integers so that I can use Date …

Read More
Change date format in a Java string

I've a String representing a date. String date_s = "2011-01-18 00:00:00.0"; I'd like to convert it to a Date and output it in YYYY-MM-DD format. 2011-01-18 How can I achieve this? Okay, based on the answers I retrieved below, …

Read More
Converting string to Date and DateTime

If I have a PHP string in the format of mm-dd-YYYY (for example, 10-16-2003), how do I properly convert that to a Date and then a DateTime in the format of YYYY-mm-dd? The only reason I ask for both …

Read More