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 |
|
maloy
Starting Member
19 Posts |
 Posted - 2002-06-17 : 07:36:49
|
| I have a job's start-time as a datetime field in the table. I'm able to use max/min to get the max/min times taken for the job to start. But I cannot use the average function to get the average starting time for the job over a period. Any leads on how to go about this in a single sql command w/o temp tables etc.-which i don't have permissions to create...tiamaloy |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-06-17 : 08:10:08
|
| Hello!If you are only interested in the time parts, I suggest splitting the time up using the datepart function and going from there. You could experiment with converting the date/time to a float value, then calculating the average, and convert it back.Regards,Kalle Dahlberg |
 |
|
|
|
|
|
Average of datetime values