How to convert string to date BigQuery 2023-02-13 00:00:00.000000000

278 Views Asked by At

Help me please! I have date to string fotmat in
2023-02-13 00:00:00.00000000 Any conversion ends with an error. tried a lot of ways. Has anyone experienced something similar?

I try this PARSE_DATETIME('%m/%d/%Y',date) PARSE_DATE('%m/%d/%Y',date) PARSE_TIMESTAMP("%Y-%m-%d%H:%M:%S%Ez"

and many more tries... Failed to parse input string "2023-02-13 00:00:00.000000000"

how to convert it correctly? is it possible to take out the first part of the date and convert it?

I try this PARSE_DATETIME('%m/%d/%Y',date) PARSE_DATE('%m/%d/%Y',date) PARSE_TIMESTAMP("%Y-%m-%d%H:%M:%S%Ez"

and many more tries...

Failed to parse input string "2023-02-13 00:00:00.000000000"

0

There are 0 best solutions below