Post reply

ISDATE( ) = 1 ?

  • September 29, 2005 at 8:22 pm

    #166102

    Does anyone know why when I use ISDATE fucntion to a char field with 4-digit number value, the function returns 1?  For Example

    SELECT ISDATE(6372)

    SELECT ISDATE(2577)

    SELECT ISDATE(8844)

    I am expecting that the example above will return 0 as those values are not dates.

     

    Thanks.

  • September 29, 2005 at 8:40 pm

    #594240

    I believe sql is doing an implicit conversion of int to date.

  • September 29, 2005 at 9:00 pm

    #594242

    Yup 0 = 1900/01/01 so it's definitly a date .

  • September 30, 2005 at 11:50 am

    #594387

    And SELECT ISDATE(6372) returns 1917-06-13 00:00:00.

    There is no "i" in team, but idiot has two.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply