sql时间类型转换
时间:2011-04-27 来源:穆俊宇
SELECT student.cy as 年级,student.xh as 学号,student.xm as 姓名,student.bh as 班级,StatusOfstudent_1.statusname as 旧状态, StatusOfstudent.statusname as 新状态,StatusLogOfstudent.mem as 原因,updatedate as 更新日期
FROM dbo.Student INNER JOIN
dbo.StatusLogOfstudent ON dbo.Student.KSH = dbo.StatusLogOfstudent.Ksh INNER JOIN
dbo.StatusOfstudent AS StatusOfstudent_1 ON dbo.StatusLogOfstudent.OldStatus = StatusOfstudent_1.Id INNER JOIN
dbo.StatusOfstudent ON dbo.StatusLogOfstudent.NewStatus = dbo.StatusOfstudent.Id
where student.cy like '%' and xh like '%' and xm like '%' and bh like '%'
and StatusOfstudent_1.statusname like '%' and StatusOfstudent.statusname like '%'
and StatusLogOfstudent.mem like '%'
and cast(updatedate as datetime)>'2008-1-1' and cast(updatedate as datetime)<'2009-1-1'