SQL中处理时间问题案例

1. 获取数据库中当前月份的相关数据
SELECT WorkerSortID, SUM(WorkerCount) AS WorkerMothCount
from WorkerRecord
WHERE (YEAR(WorkerTime) = YEAR({ fn NOW() })) AND (MONTH(WorkerTime)
      = MONTH({ fn NOW() })) AND (WorkerCount > 0) AND (WorkerID = 'wy')
GROUP BY WorkerSortID
2. 获取数据库中的存在时间数据，时间格式为：1999-11
SELECT CONVERT(varchar(10), YEAR(WorkerTime)) + '-' + CONVERT(varchar(10),
      MONTH(WorkerTime)) AS WorkTime
from WorkerRecord
GROUP BY CONVERT(varchar(10), YEAR(WorkerTime)) + '-' + CONVERT(varchar(10),
      MONTH(WorkerTime))
3. 获取数据库中指定时间段的相关数据
SELECT WorkerSortID, SUM(WorkerCount) AS WorkerMothCount
from WorkerRecord
WHERE (WorkerCount > 0) AND (WorkerTime < CONVERT(varchar(30), '2008-12-31', 101)) AND (WorkerID = 'wy')
GROUP BY WorkerSortID