Significance of -53960

• SQL_GURU (I wish!)

  Grasshopper

  Points: 12

  More actions

  March 24, 2010 at 10:35 am

  #217061

  Please advise what's the meaning/significance of the -53960 in the following datadiff function call?

  datediff(dd,-53690,<some date>)

  :unsure:

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 24, 2010 at 11:24 am

  #1139095

  Represents 1753-01-01, the earliest allowed date for a datetime value iirc.

• SQL_GURU (I wish!)

  Grasshopper

  Points: 12

  More actions

  March 24, 2010 at 5:28 pm

  #1139307

  Thanks Lynn, the rest of the thing I was working on is all starting to make sense now.