Parsing string date to date format

David Salomon

I'm having issues parsing a string to a date format.

This is my string 7/13/2022 9:46 AM

As per the documentation, I'm trying PARSE_DATETIME("%x %R %p", datetime_closed) or PARSE_DATETIME("%D %E4Y %R %p", "7/13/2022 9:46 AM")

I've tried other combinations but none of them works

Poala Astrid

You can use the format below:

PARSE_DATETIME('%m/%d/%Y %l:%M %p', "7/13/2022 9:46 AM")

The output:

parse_datetime_output

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related