Loading

Leap year increment

sathish

7y960SQL

Hi,

I have a logic to increment the year by 1 ..so the below one I used in sql

@date='2019-01-31'

select dateadd(year,1,@date')

It gives me result as '2020-01-31'

@date='2019-02-28'

But for Feb since 2020 leap year if I do the same its gives result as '2020-02-28' instead should

give '2020-02-29'

Kindly let me know the query to verify and get this one.

Thanks

Sathish

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jefferson S. Motta7y ago
But if returns '2020-02-29' will be one year and one day! What you are looking for is the last day of the month?
0
Priyanka Jain7y ago
For adding month and year Refer below link it may help,

https://www.sqlservercentral.com/forums/topic/dateadd-and-leap-years

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0cb77805-f71f-4e53-8d5d-c905786836b0/leap-year-calculation-logic-by-sql?forum=transactsql

https://blog.sqlauthority.com/2012/03/03/sql-server-various-leap-year-logics/
0