select from Expenzsection where SectionName39bm39 and date between 390101201539 and 390401201539 order by date

Date Format used in SQL is yyyymmdd so change tbe between clause asbetween 392015010139 and 392015010439

حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

SQL Server - Comparing between Dates in WHERE Statement not working correctly

celv

select *  from Expenzsection where SectionName='bm' and date  between '01/01/2015' and '04/01/2015' order by date

Mudassar

0 4

Date Format used in SQL is yyyy-mm-dd so change tbe between clause as

between '2015-01-01' and '2015-01-04'