Adding Time

Question

Adding Time

Steve Jones - SSC Editor

SSC Guru

Points: 738347
More actions
January 17, 2022 at 12:00 am

#3966077

Comments posted to this topic are about the item Adding Time

Viewing 4 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1004619 More actions · Answer 1

Heh... it's a real shame that MS didn't follow the ISO/ANSI standards when it came to the "new" (now old) DATE, TIME, and DATETIME2 datatypes and it's also a shame that they haven't exploited the power built into the DATETIME datatype at all.

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

Jeff Moden SSC Guru Points: 1004619 More actions · Answer 2

I have to admit that I'm a bit gobsmacked at the number of people (50% at the time of this posting) that think there's such a thing as DATEADD(time,.....

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

Robert Sterbal-482516 SSCrazy Points: 2874 More actions · Answer 3

Jeff Moden wrote:

I have to admit that I'm a bit gobsmacked at the number of people (50% at the time of this posting) that think there's such a thing as DATEADD(time,.....

well there is this: https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15

Adding Time

Cookies on SQLServerCentral