Home Forums Article Discussions Article Discussions by Author Discuss content posted by Seth Phelabaum Date Manipulation with DATEADD/DATEDIFF RE: Date Manipulation with DATEADD/DATEDIFF

  • April 8, 2010 at 7:11 am

    #1148243

    SQLJeff (4/8/2010)

    And what about the old CONVERT(VARCHAR(12),GETDATE(),101), will this work in some cases?

    Most likely... but the problem with that is as I previously stated... it uses twice as much CPU time and takes twice as long duration wise. If you're only working with a handful of rows, you certainly won't notice the difference. BUT, if you're working with many millions of rows like I usually have to, combined with other CPU saving methods, it makes all the difference in the world. Every microsecond counts for the stuff I usually have to do.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)