时间段查询: sqlserver: WHERE (CONVERT(CHAR(8), AUDIT_TIME,112) BETWEEN '20121205' AND '20121205'); oracle: WHERE to_char(AUDIT_TIME,'yyyymmdd') BETWEEN '20101205' AND '20121205';