Add 365 days to getdate()

Hello, how do you add 365 days to getdate()?
gogetsomeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
Select GetDate() + 365
0
 
gogetsomeAuthor Commented:
Duh, that was easy...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
actually, you might be better off with this:
SELECT DATEADD(year, 1, getdate())

Open in new window

0
 
gogetsomeAuthor Commented:
Thanks Angel!
0
All Courses

From novice to tech pro — start learning today.