Bruno Ripa
Reputation: 873
Converting BigQuery string to datetime
I have a bq table withhas a column timestamp as a string, with format 20090630 16:36:23:880, how can I convert it to a proper timestamp ?
Upvotes: 0
Views: 258
Answers (1)
Mikhail Berlyant
Reputation: 173171
parse_datetime('%Y%m%d %H:%M:%E3S', '20090630 16:36:23.880')
Upvotes: 2
Related Questions
- Parse string to TIMESTAMP BigQuery
- How to Convert STRING to DATETIME in BIG QUERY
- BIGQUERY DATETIME STRING Conversion
- Bigquery converting string to timestamp
- How to convert BigQuery TIMESTAMP to Date in Google Apps Script?
- Bigquery convert string to datetime
- How to convert string to timestamp into bigquery
- BigQuery: String to Timestamp
- BigQuery TIMESTAMP TO DATETIME
- String to date time conversion Bigquery