In ms sql database we are querying database from 25th april to 26th april and getting 50 records.
However when we are querying from 25th April to 25th April we are getting 0 records
, when we are querying from 26th april to 26th april we are getting 0 records. Can you please look where we are going wrong. Here is the query we are using for this problem.
select count(b.RECORD_LOCATOR) AS RECORD_LOCATOR from TEST.DBO.EMPL_RECORD_LOCAT
OR_INFO a , TEST.DBO.CREDIT_CARD_PAID_
PNR b where a.RECORD_LOCATOR = b.RECORD_LOCATOR AND a.BOOKING_DT BETWEEN '"+(String)al.get(0)+"' AND '"+(String)al.get(1)+"'"
Start Free Trial