Home Forums SQL Server 2008 T-SQL (SS2K8) Need to find out whether date is of which data type RE: Need to find out whether date is of which data type

  • January 9, 2013 at 3:01 am

    #1575119

    dwain.c (1/9/2013)

    anthony.green (1/9/2013)

    ISDATE

    Returns 1 if the expression is a valid date, time, or datetime value; otherwise, 0.

    ISDATE returns 0 if the expression is a datetime2 value.

    You are assuming sir that I read BOL. 😛 It is much more fun to experiment. 😀

    Yep you are assuming that I read BOL too, I also fell into this trap when first looking at this yesterday.