Bigquery converting string to timestamp

Question

Whats the best way to convert a string value like this to a timestamp?

"2021-05-11T02:00:03.4897671"

I tried the below

select PARSE_TIMESTAMP("%Y-%m-%d %H:%M:%E#S", "2021-05-11T02:00:03.4897671")

But I get the following error

Failed to parse input string "2021-05-11T02:00:03.4897671"

Sergey Geron · Accepted Answer · 2021-05-19 18:23:13Z

1

Try this:

select PARSE_TIMESTAMP("%Y-%m-%dT%H:%M:%E*S", "2021-05-11T02:00:03.4897671")

answered May 19, 2021 at 18:23

Sergey Geron

10.5k4 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1