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

 

How to convert string to date in Google BigQuery  when date have format string and 2023-02-13 00:00:00.000000000

I have used many conversion methods like , but none of them helped.

PARSE_DATETIME('%m/%d/%Y',date)  PARSE_DATE('%m/%d/%Y',date) PARSE_TIMESTAMP("%Y-%m-%d%H:%M:%S%Ez" PARSE_TIMESTAMP("%F %H:%M:%E*S","2023-02-13 00:00:00.000000000") ?

There is only one way - using split(date," ")[offset(0)] as date,