Difference between Datediff('DD') & Datediff('D')

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  February 18, 2009 at 10:50 pm

  #205759

  Hi All,

  I am using DateDiff function to find out the difference in number of days between 2 dates. [select Datediff(DD, '2009-02-10', getdate())]

  I get same answer when I use 'D' in place of 'DD'. I would like to know what's the diff between 'D' & 'DD' ?

  Regards,

  swmsan

• ps.

  One Orange Chip

  Points: 29423

  More actions

  February 18, 2009 at 11:06 pm

  #946480

  both are identical.

  refer BOL.

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/15f1a5bc-4c0c-4c48-848d-8ec03473e6c1.htm

  ---

  
  Pradeep Singh

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  February 19, 2009 at 1:06 am

  #946493

  swmsan (2/18/2009)

  ---

  Hi All,

  I am using DateDiff function to find out the difference in number of days between 2 dates. [select Datediff(DD, '2009-02-10', getdate())]

  I get same answer when I use 'D' in place of 'DD'. I would like to know what's the diff between 'D' & 'DD' ?

  Regards,

  swmsan

  Use day in place of DD or D for clarity

  ---

  Madhivanan

  Failing to plan is Planning to fail