[!INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw.md)] Returns a null value if the two ...

When casting nullif('', '') to Date/DateTime types using toDate()/toDateTime() ClickHouse returns exceptions: SQL Error [38]: ClickHouse exception, code: 38, host ...

The NULLIF function returns a null value if the arguments are equal, otherwise it returns the value of the first argument. The arguments must be comparable (see Assignments and Comparisons). They can ...