Date add with Different DataType

  • This was removed by the editor as SPAM

  • Interesting, very interesting. Thanks, Paresh!

  • Easy one, thanks.

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

  • 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

  • Nice.....

  • 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

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

Viewing 7 posts - 16 through 21 (of 21 total)

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