现在找到任何记录的RANGE SELECT DATE [英] RANGE SELECT DATE NOW FOUND ANY RECORD

问题描述

你好朋友

我想查找今天到5天之前的记录.这是我的查询，但找不到并重新记录

Hello friend

i want to find record between todays date to before 5 days. here my query but its doesn''t find and reocrd

select * from OrderMaster where OrderDate between CONVERT(char(8),GETDATE(),112) and CONVERT(char(8),(GETDATE()-5),112)

是否有任何想法选择记录

is there any idea to select the record

推荐答案

我不确定100％，但是我认为您的between子句的参数顺序错误.如果我看一下MSDN文档:

http://msdn.microsoft.com/en-us/library/ms187922.aspx [ ^ ]

日期的ween子句示例首先具有最低的日期，因此您的查询应如下所示:

I''m not 100% sure but I think your parameters for your between clause are in the wrong order. If I look at the MSDN documentation:

http://msdn.microsoft.com/en-us/library/ms187922.aspx[^]

The between clause example for dates has the lowest date first, so you query would look like this:

select * from OrderMaster where OrderDate between CONVERT(char(8),(GETDATE()-5),112) and CONVERT(char(8),GETDATE(),112)

这篇关于现在找到任何记录的RANGE SELECT DATE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！