DATE_PARSE takes a string or integer representing a date, parses it according to a provided format and timezone, then returns an object with a variety of useful information, including:
Integer representations of the year, month, day of the month, day of the week, hour, minute, second, and millisecond
Name of the month, day, and timezone
ISO8601 and unix timestamp representations of the date
This object can be passed to
If the parse format argument isn't provided, it will attempt to guess the format, but explicit formats can be used to reliably parse ambiguous dates like 01/02/2023, which is January 2nd in EU-format and February 1st in US-format.