I have number of days then how can i convert these numbers into yyyy/mmm/dd format in SQL server.
In mytable i have one column that is "NoOfElapsDays"
NoOfElapsDays
---------
255
888
569
989
----------
I want o/p as
1 Year 3 month 5 days
...
Go to the complete details ...