How to insert string “dd/mm/yy hh:mm:ss” into datetime column in bigquery

Question

I need to insert string “10/11/2019 12:34:45” into datetime column in bigquery , please advise any options ?

Does this answer your question? [STRING to DATE in BIGQUERY](https://stackoverflow.com/questions/44564887/string-to-date-in-bigquery) — Igor, Jul 09 '20 at 19:01

Mikhail Berlyant · Accepted Answer · 2020-07-09T22:07:31.347

1

Below is for BigQuery Standard SQL

you can use

PARSE_DATETIME('%d/%m/%Y %T', datetime_col_as_string) datetime_col_as_datetime

for example, SELECT PARSE_DATETIME('%d/%m/%Y %T', '10/11/2019 12:34:45') produces datetime value as in below

Row datetime_col_as_datetime     
1   2019-11-10T12:34:45

edited Jul 09 '20 at 22:07

answered Jul 09 '20 at 21:31

Mikhail Berlyant

Yes it worked for me , Thanks for that :) New Issue - getting new error( String "Yes" is not converting to bool using cast ) any advise here ? – Harshith S H Jul 10 '20 at 10:10
@HarshithSH I suggest that you accept his answer and create another question for this new error – rmesteves Jul 10 '20 at 11:15

1 Answers1