为了处理不等式,例如,我喜欢将日期/时间转换为YYYYMM表示形式(字符串或整数)。对于此示例:
DECLARE @date1 DATETIME = CAST('6/14/2014' AS DATETIME), @date2 DATETIME = CAST('6/15/2014' AS DATETIME), @date3 DATETIME = CAST('7/1/2014' AS DATETIME);SELECt * FROM tableName WHERe @date2 BETWEEN @date1 AND @date3;
我将查询写为:
SELECt *FROM tableNameWHERe year(@date2) * 100 + month(@date2) BETWEEN year(@date1) * 100 + month(@date1) AND year(@date3) * 100 + month(@date1);
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)