String to Date and Timestamp

In BigQuery you can use the following functions

Usage examples:

Date as input Function Call
2017/02/08 TIMESTAMP(PARSE_DATE('%Y/%m/%d',date))
08/02/2017 TIMESTAMP(PARSE_DATE('%d/%m/%Y',date))
08-02-2017 TIMESTAMP(PARSE_DATE('%d-%m-%Y',date))
02082017 TIMESTAMP(PARSE_DATE('%d%m%Y',date))


String to numeric

Number as input Function call
5 CAST(number AS int64)
2.3 CAST(number AS float64)


For BigQuery’s Legacy SQL you can alternatively use the function INTEGER(number) and FLOAT(number).

in SQL Playbook