Home Forums SQL Server 2005 T-SQL (SS2K5) Conversion failed when converting datetime from character string. RE: Conversion failed when converting datetime from character string.

  • October 22, 2007 at 12:38 pm

    #744205

    No,

    ISDATE is different.

    You can use this ias an example

    DECLARE @datestring varchar(8)

    SET @datestring = '12/21/1098'

    SELECT ISDATE(@datestring)

    Above will still print out 1 because its an valid date. but still out of range for DATETIME.