Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vadz
Starting Member
11 Posts |
 Posted - 2012-11-20 : 00:25:36
|
| how to convert an average value back to years,months and days?.i convert into years now find the sum and able to find the avrage value..if i have a value like 578.5 as average..how can i convert into years, months and days?..thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-20 : 02:52:27
|
| what do you mean by convert 578.5 as years,months etc?is 578.5 average time in seconds/hours etc?Some more clarity on your source will really help!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
convert average into years months and days