获取两个日期之间的记录 [英] Get records between two dates

问题描述

我有桌子，其中有一列From_date，To_date



i want获取传递日期之间的记录作为输入



i写下我的查询，如下所示。



选择*来自表格from_date> = '10 / 01/2015'和to_date< = '10 / 30/2015'



无法获得基于传递的记录日期

解决方案

尝试 -

 选择 * 来自 表 其中 from_date> = '  2015-10-01'  AND  to_date< = '  2015-10-30' 

尝试

 选择 LR.Lunch _BookingID，
 E.EMP_NAME  as  RequestedByName，
 LR.From_Date，
 LR.To_Date，
 LR.Type_of_Requirement， 
 P.PRJ_NAME  as  Project_Name 
  From  LUNCH_REQUEST  as  LR  LEFT   OUTER  加入 
 PMS_TEST.Common.EMPLOYEE  as  E  ON  E.EMP_NO = LR。 Requested_By  INNER   JOIN  
 APPROVER_STATUS  as  APS  ON  APS.Status_ID = LR.Status_ID  INNER  加入 
 PMS_TEST.Common.PROJECT  as  P  ON  P.PRJ_ID = LR。 Project_ID 
 其中 GETDATE（）  '  2015-10-01'  AND  ' 二零一五年十月三十日'  

Hi,

I have table in which i have a columns From_date, To_date

i want to get the records between passing Dates as Input

i wrote my query as written below.

Select * from Table Where from_date >= '10/01/2015' AND to_date <= '10/30/2015'

not able get the records based on passed dates

解决方案

Try-

Select * from Table Where from_date >= '2015-10-01' AND to_date <= '2015-10-30'

Try

Select LR.Lunch_BookingID, 
E.EMP_NAME as RequestedByName, 
LR.From_Date, 
LR.To_Date, 
LR.Type_of_Requirement, 
P.PRJ_NAME as Project_Name
From LUNCH_REQUEST as LR LEFT OUTER JOIN 
PMS_TEST.Common.EMPLOYEE as E ON E.EMP_NO = LR.Requested_By INNER JOIN 
APPROVER_STATUS as APS ON APS.Status_ID = LR.Status_ID INNER JOIN 
PMS_TEST.Common.PROJECT as P ON P.PRJ_ID = LR.Project_ID 
Where GETDATE() between '2015-10-01' AND '2015-10-30'

这篇关于获取两个日期之间的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！