ETL: IsISODatetime

Check whether a string expression conforms to ISO 8601 date time format. Returns true or false for date validation in Integrate.io ETL pipelines.

Description

Checks if a string expression is in ISO 8601 date time format.

Syntax

IsISODatetime(string_expression)

Examples

IsISODatetime('aksjhfkasjhfkjashf') returns false.

IsISODatetime('1997-07-16T19:20:30+01:00') returns true.

Return value datatype

Boolean

Impact of null value

If input is null, returns null.