IS_DATE_UDF

Description

The ISDATE function determines whether an expression is a valid date type. Returns 1 if the expression is a valid datetime value; otherwise, 0. (SQLServer documentation)

SQLServer syntax

ISDATE ( expression )

Custom UDF overloads

Parameters

1. VAL: A varchar expression that represents the value to be evaluated and determine is it is a valid date type.

UDF

CREATE OR REPLACE FUNCTION IS_DATE_UDF(VAL VARCHAR)
RETURNS BOOLEAN
LANGUAGE SQL
IMMUTABLE
AS 
$$
    SELECT IFF(TRY_TO_DATE(VAL) IS NULL, 0, 1) = 0
$$;

SQL Server

Query

SELECT ISDATE('04-15-2008');

Result

1

Snowflake

Query

SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'IS_DATE_UDF' INSERTED. **
IS_DATE_UDF('04-15-2008');

Result

IS_DATE_UDF('04-15-2008')
TRUE

Related EWIs

1. MSCEWI1020: CUSTOM UDF INSERTED.