Click here to Skip to main content
16,016,712 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dateofbirth Textbox1

In textbox1 i have today'sdate 25/09/2015

from the above todays i want to add 60 days. for that how can i do using sql server.

i want to get the output as follows

25/11/2015 (Output i wan to get).
Posted

Use the SQL DateAdd[^] function
 
Share this answer
 
Use below syntax
SQL
DATEADD(datepart,number,date)
 
Share this answer
 
Comments
CHill60 25-Sep-15 9:03am    
Which is exactly what is on the link to the documentation that I provided earlier!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900