Determine dates by number of days, "which date is 180 days

Question

How to determine the dates by the number of days from now - "What date is 180 days?"

Answer 1

DATEADD(d, 180, GetDate())

Answer 2

SELECT DATEADD(day, 180, getdate())

Answer 3

getdate() + 180

eg:

select getdate() as Today, getdate() + 180 as About6MonthsLater

Answer 4

Since you just need a date, part of the time should be deleted after the calculation is complete.

SELECT CONVERT (DATETIME, CONVERT (VARCHAR (20), DATEADD(d, 180, GetDate()), 101))

Answer 5

To find 180 days in advance and remove the time component at a time.

Do not rely on internal implementation (using +) or line processing to interrupt time.

SELECT DATEADD(day, DATEDIFF(day, 0, GETDATE()), 180)