How do I cast dd/mm/yyyy string into date in BigQuery?

datetime casting google-bigquery string-to-datetime
Saurabh Kumar picture Saurabh Kumar · Mar 12, 2015 · Viewed 15.2k times · Source

I have 3 columns 1. dd/mm/yyyy (stored as a string) 2. app_id and #downloads of apps

I have to find unique ids of apps downloaded within a week.

Thank you

Answer

Graham Polley picture Graham Polley · Feb 8, 2017

Even shorter using standard SQL:

SELECT TIMESTAMP(PARSE_DATE('%d/%m/%Y','23/03/2015'))

Related questions

String was not recognized as a valid DateTime " format dd/MM/yyyy"

I am trying to convert my string formatted value to date type with format dd/MM/yyyy. this.Text="22/11/2009"; DateTime date = DateTime.Parse(this.Text); What is the problem ? It has a second override which asks for IFormatProvider. What is …

Read More
A better CDate for VB6

We have a a VB6 app (in a COM component) which uses CDate() to take a string and cast it to a Date, for storing in a database. Depending on if we want the application to talk in dd/MM/…

Read More
How to get the current time in Python

What is the module/method used to get the current time?

Read More