ISDATE( ) = 1 ?

• Mon-257021

  SSC-Addicted

  Points: 468

  More actions

  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.

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  September 29, 2005 at 8:40 pm

  #594240

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

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 29, 2005 at 9:00 pm

  #594242

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

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  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.