Determine dates by number of days, "what date is 180 days from now

How to determine dat开发者_如何学编程es by number of days from now - "What date is 180 days from now?"

DATEADD(d, 180, GetDate())

SELECT DATEADD(day, 180, getdate())

getdate() + 180

for example:

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

Since you just want the date, the time part should be stripped out after the calculation is done.

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

To find 180 days ahead and remove the time component in one easy go.

No relying on internal implementation (using +) or string handling to chop time.

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