bigfunctions > parse_date

parse_date

Signature

parse_date(date_string)

Description

Parse date with automatic format detection (inspired from Sebabrata BigQuery tutorial)

Examples

EUUSeurope-west1

select bigfunctions.eu.parse_date('2021-01-20 ')

select bigfunctions.us.parse_date('2021-01-20 ')

select bigfunctions.europe_west1.parse_date('2021-01-20 ')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+

EUUSeurope-west1

select bigfunctions.eu.parse_date('2021-1-20 ')

select bigfunctions.us.parse_date('2021-1-20 ')

select bigfunctions.europe_west1.parse_date('2021-1-20 ')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+

EUUSeurope-west1

select bigfunctions.eu.parse_date('2021/01/20 ')

select bigfunctions.us.parse_date('2021/01/20 ')

select bigfunctions.europe_west1.parse_date('2021/01/20 ')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+

EUUSeurope-west1

select bigfunctions.eu.parse_date('2021/1/20 ')

select bigfunctions.us.parse_date('2021/1/20 ')

select bigfunctions.europe_west1.parse_date('2021/1/20 ')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+

EUUSeurope-west1

select bigfunctions.eu.parse_date('01/20/21')

select bigfunctions.us.parse_date('01/20/21')

select bigfunctions.europe_west1.parse_date('01/20/21')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+

EUUSeurope-west1

select bigfunctions.eu.parse_date('1/20/21')

select bigfunctions.us.parse_date('1/20/21')

select bigfunctions.europe_west1.parse_date('1/20/21')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+

EUUSeurope-west1

select bigfunctions.eu.parse_date('Wed Jan 20 21:47:00 2021')

select bigfunctions.us.parse_date('Wed Jan 20 21:47:00 2021')

select bigfunctions.europe_west1.parse_date('Wed Jan 20 21:47:00 2021')

+--------------------+
| cleaned_date       |
+--------------------+
| date('2021-01-20') |
+--------------------+