Adding Time

Question

Adding Time

Steve Jones - SSC Editor

SSC Guru

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

#3966077

Comments posted to this topic are about the item Adding Time
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 18, 2022 at 10:43 am

This was removed by the editor as SPAM

Viewing 5 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: 1000363 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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000363 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)
Intro to Tally Tables and Functions

Robert Sterbal-482516 SSCrazy Points: 2794 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