Get only year part from date string in SQL server

Posted by Vishalneeraj-24503 under Sql Server on 12/1/2021 | Points: 10 | Views : 2624 | Status : [Member] [MVP] | Replies : 0
I have following Date string format :-

2.04 Years
0.06
2 Years
0
Now my requirement is ->

extract Year as 2 / 0 without Years keyword.
extract Month as 4 / 6 / Calculate month from above like calculate month from 2 years





Responses

(No response found.)

Login to post response