ParseDate

Description

Convert input datetime string to datetime data type, using the first format that matches the string.

Syntax

ParseDate(datetime_string, format_string_1, ..., format_string_n)

Examples

ParseDate('2015-05-02','dd/MM/yyyy','yyyy-MM-dd') returns a datetime expression 2015-05-02T00:00:00Z
ParseDate('Hi!','dd/MM/yyyy','yyyy-MM-dd') returns a datetime null expression.

Return value datatype

datetime

Impact of null value

If custom_string is null, null is returned.
If format strings are null, an exception is raised.
If no format matches the input string, null is returned.

Feedback and Knowledge Base