Remove minutes from datetime - sql

Question

DECLARE @MinutesToAdd int = 20; DECLARE @StartTimeDate datetime = '2017-06-05 14:37:56.113'; DATEADD(minute,@MinutesToAdd,@StartTimeDate);

Code above adds 20 minutes to StartTimeDate. Is there a good way to remove those 20 minutes not add? Tried to find a solution, but didn't catch one. Any ideas?

Please add the DBMS tag

Jens
– Jens

2017-06-16 07:00:48 +00:00
Commented Jun 16, 2017 at 7:00 — Jens
– Jens, Commented Jun 16, 2017 at 7:00
try passing -20

pritesh agrawal
– pritesh agrawal

2017-06-16 07:01:25 +00:00
Commented Jun 16, 2017 at 7:01 — pritesh agrawal
– pritesh agrawal, Commented Jun 16, 2017 at 7:01
Added sql server tag based on the syntax used

Pரதீப்
– Pரதீப்

2017-06-16 07:04:19 +00:00
Commented Jun 16, 2017 at 7:04 — Pரதீப்
– Pரதீப், Commented Jun 16, 2017 at 7:04

Pரதீப் · Accepted Answer · 2017-06-16 07:01:57Z

You don't have any specific function to subtract any dateparts

Just add negative symbol in front

Select DATEADD(minute,-@MinutesToAdd,@StartTimeDate);

or multiply with -1

Select DATEADD(minute,@MinutesToAdd * -1 ,@StartTimeDate);

score 0 · Accepted Answer · 2017-06-16 07:34:42Z

Try this:

 DECLARE @MinutesToAdd int = -20; DECLARE @StartTimeDate datetime = '2017-06-05 14:37:56.113'; select DATEADD(minute,@MinutesToAdd,@StartTimeDate);

Collectives™ on Stack Overflow

Remove minutes from datetime - sql

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related