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 |
|
downeyle
Starting Member
1 Post |
 Posted - 2008-08-15 : 19:30:18
|
| How do you display the average days between several date ranges extracted from a list of data? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-15 : 20:03:00
|
depending on your requirement. Show in whole number or in decimals
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-16 : 01:09:12
|
| using AVG() function. and if you want to display average based on particular group first group data based on required fields using GROUP BY and then apply AVG over field to be averaged. As asked earlier, remember to cast it to decimal if you need results in decimal. |
|
|
|
|
|
|
Date Format