How to parse a string time '16-AUG-22 01.50.20' to datetime bigquery-CodePudding

Home > Net > How to parse a string time '16-AUG-22 01.50.20' to datetime bigquery

How to parse a string time '16-AUG-22 01.50.20' to datetime bigquery

Time：09-03

How can I parse a following string timestamp to timestamp from BigQuery: "16-AUG-22 01.50.20.000000 PM"?

CodePudding user response：

Use below as an example

select parse_timestamp('%d-%b-%y %I.%M.%E*S %p', "16-AUG-22 01.50.20.000000 PM")

with output