출근시간 (datetime 형식)
2008-03-19 오전 6:00:46
2008-03-19 오전 6:01:11
2008-03-19 오전 6:01:29
2008-03-19 오전 6:02:14
2008-03-19 오전 6:04:57
2008-03-19 오전 6:05:30
2008-03-19 오전 6:06:02
2008-03-19 오전 6:07:08
2008-03-19 오전 6:07:34
2008-03-19 오전 6:11:34
2008-03-19 오전 6:11:38
2008-03-19 오전 6:11:49
---
해당 출근 데이타가 있는데..
출근시간의 평균을 알고 싶은데요..
어떻게 해야할지 영 감이 안 옵니다..
고수님들의 답변 부탁드립니다...
SELECT CAST(AVG(CAST(DT AS FLOAT)) AS DATETIME) FROM ( SELECT DT = CAST('2008-03-19 6:00:46' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:01:11' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:01:29' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:02:14' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:04:57' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:05:30' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:06:02' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:07:08' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:07:34' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:11:34' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:11:38' AS DATETIME) UNION ALL SELECT DT = CAST('2008-03-19 6:11:49' AS DATETIME) ) Q
. 님..
너무 감사합니다.