one issue in sql,i want next minute of current date/time

Question

by using GETDATE(),i can get current date and time like 2019-11-20 15:04:22 but i need next minute like 2019-11-20 15:05:00

This is already answered.Please have a look. https://stackoverflow.com/questions/33760529/how-to-add-minutes-to-the-time-part-of-datetime — Its_Ady, Nov 20 '19 at 15:59
Possible duplicate of [How to add minutes to the time part of datetime](https://stackoverflow.com/questions/33760529/how-to-add-minutes-to-the-time-part-of-datetime) — A. S. K., Nov 20 '19 at 16:00
in standard SQL this would be `current_timestamp + interval '1' minute` — , Nov 20 '19 at 20:51

score 0 · Answer 1 · answered Nov 20 '19 at 16:00

0

    CONVERT(DATETIME, CONVERT(SMALLDATETIME,
  DATEADD(minute, CASE WHEN d = CONVERT(SMALLDATETIME, d) THEN 0 ELSE 1 END,
  d)))

answered Nov 20 '19 at 16:00

Yakir Malka

score 0 · Answer 2 · answered Nov 20 '19 at 20:44

One approach is to calculate the number of minutes since some point in time, add 1, and add that back to the original point in time.

0 is a convenient time for this purpose:

select dateadd(minute, datediff(minute, 0, dt) + 1, 0)
from (values (convert(datetime, '2019-11-20 15:04:22'))) v(dt)

2 Answers2