Timeline for Extract Year only from 'Select @@version' output
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2020 at 22:27 | comment | added | Ali | Thank you that indeed was the right trick and found the a related answer. | |
| Feb 5, 2020 at 22:26 | answer | added | Ali | timeline score: 3 | |
| Feb 5, 2020 at 22:19 | comment | added | Bob Klimes | In the output of version there are 4 possible years so parsing it for year can be problematic. Can you use product version instead of year: SELECT @SQLVersion serverproperty('ProductMajorVersion') . 15= 2019, 14=2017, 13= 2016 | |
| Feb 5, 2020 at 22:06 | history | asked | Ali | CC BY-SA 4.0 |