Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
SQL Server Transact Basic to Expert - Incrementing a date value (Year) using query
WhatsApp
Karthikeyan Anbarasan
13y
3.8
k
0
0
25
Blog
This blog shows how to do an year increment in the output using SQL Query
Example:
SELECT DATEADD(yy, -1, '2/2/2010')
The expected result would be 2011-02-02 00:00:00.000
Up Next
SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query
Ebook Download
View all
Introducing Microsoft SQL Server 2016
Read by 11k people
Download Now!
Learn
View all
Membership not found