Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

STRING to DATE in BIGQUERY

Tags:

string

date

google-bigquery

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.

like image

272

asked Jun 15 '17 10:06

Lucasaudati11

People also ask

What is the date format in BigQuery?

The date in the format %m/%d/%y. The day of the month as a decimal number (01-31). The day of month as a decimal number (1-31); single digits are preceded by a space. The date in the format %Y-%m-%d.

Video Answer

1 Answers

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

like image

193

answered Oct 29 '22 00:10

Felipe Hoffa

Sign in to Comment

Related questions
                            
                                When to use Rabin-Karp or KMP algorithms?
                            
                                Bash: manipulating with strings (percent sign)
                            
                                What is the Big-O of String.contains() in Java?
                            
                                Is there an equivalent to the Scanner class in C# for strings?
                            
                                Best way to format a date relative to now on Android
                            
                                Python string 'in' operator implementation algorithm and time complexity
                            
                                String concatenation complexity in C++ and Java [duplicate]
                            
                                Java8 Streams - Remove Duplicates With Stream Distinct
                            
                                Is regex too slow? Real life examples where simple non-regex alternative is better
                            
                                Extending builtin classes in python
                            
                                Splitting a string by list of indices
                            
                                MySQL SELECT query string matching
                            
                                C++ std::string append vs push_back()
                            
                                Reversal of string.contains In python, pandas
                            
                                Logical operator && and two strings in javascript
                            
                                What exactly does String.codePointAt do?
                            
                                How do I pass multiple string parameters to a PowerShell script?
                            
                                In Ruby unit tests, how to assert that a string contains certain substring?
                            
                                Slice a string in groovy
                            
                                Python reverse-stride slicing

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With