Home Forums SQL Server 2008 T-SQL (SS2K8) Adding Seconds to Time field RE: Adding Seconds to Time field

  • August 30, 2012 at 8:33 pm

    #1532182

    dwain.c (8/30/2012)

    Jeff Moden (8/30/2012)

    Like I said... serious problem.

    Jeff - I don't get it (no coffee yet this morning).

    If it starts at 23:59:00 and ends at 00:01:00 (120 seconds), what is the problem?

    It depends... on whether or not that's the desired effect. If you're trying to aggregate time (for example) then the wrap at 24 hours is a killer on a TIME "field".

    --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)