Date add with Different DataType

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  June 21, 2013 at 2:55 pm

  #1626500

  Interesting, very interesting. Thanks, Paresh!

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  June 23, 2013 at 1:51 pm

  #1626621

  Easy one, thanks.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• David Conn

  SSCertifiable

  Points: 6010

  More actions

  June 24, 2013 at 3:36 am

  #1626700

  I find this QOTD annoying as it ends up implying that DATETIME is somehow superior to DATE when it isn't.

  It has taken Microsoft a long time to add DATE and TIME data types to SQL Server. These Data types don't do +1 as this is meaningless. What does the 1 represent ? How can you add an integer to a Date ?

  I really would like DATETIME to be deprecated although I know this isn't likely mainly because of its prevalence.

  Regards

  David

• Bangla

  Hall of Fame

  Points: 3137

  More actions

  June 24, 2013 at 4:01 am

  #1626709

  Nice.....

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  June 28, 2013 at 5:23 pm

  #1628457

  thanks for the question

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  July 1, 2013 at 4:09 am

  #1628651

  Good quesiton showing the difference in nature of both date datatypes.