求一条时间SQL

[il525li]

想查出一个人某一个月的考勤记录统计
考勤表是这样的
id intime outtime
一天一个上下班

要查出某一个人这一个月都是哪天上的班的统计值
id monthDay time
1 1号 8小时
1 3号 7小时
1 6号 11小时

求高手解答

[SQL77]

select *,datediff(hh,intime, outtime) hh from tb

[xuam]

select id,datepart(day,intime) [monthDay],datediff(hh,intime, outtime) [time] from tb

[--小F--]

select id,ltrim(datepart(dd,intime))+'号' [monthDay],datediff(hh,intime, outtime) [time] from tb

[gogodiy]

SELECT	YEAR(intime) AS [年],
		MONTH(intime) AS [月],
		DAY(inttime) AS [日],
		LTRIM(DATEDIFF(HOUR,inttime,outtime))+'小时' AS [工作时间]
FROM	[考勤表]