less than equal to not working.

[kamill]

I need to generate a report (with fromdate and todate).If we set the “from” date and “to” dates as the same it should generates a report for that date.
If we set the “from” date as one day before the “to” date it generates a report for two days…..

And so on….

But i am unable to generate report for current date, less then equal to not working it treated as less then only.
my query is following.

SELECT `date_time` FROM `mydatatable` where `date_time` >= '$fromdate' AND `date_time` <= '$todate';

[dafodil]

Check if the $todate has the same format as date_time and $fromdate

[kamill]

Check if the $todate has the same format as date_time and $fromdate

$todate and $fromdate both are same

suppose i want to access report of current date, my query is

select * from `mydatatable` where `date_time` >= '2007-08-01' and `date_time` <= '2007-08-01'; 

But this query not return any record, if i change to date by 2007-08-02, then it will return result for today date.

[dafodil]

$todate and $fromdate both are same

suppose i want to access report of current date, my query is
select * from `mydatatable` where `date_time` >= '2007-08-01' and `date_time` <= '2007-08-01';

But this query not return any record, if i change to date by 2007-08-02, then it will return result for today date.

Do you use timestamp for the dates? Maybe because you are using text. You should convert them to timestamp. and do not compare them to strings use numbers like '20070802000000'.

[mwasif]

Kinldy use appropriate code tags when posting code/syntax. Please follow this site's Posting Guidelines when posting questions or answers.

[mwasif]

Try this query

SELECT * FROM `mydatatable` WHERE `date_time` >= '2007-08-01 00:00:00' AND `date_time` <= '2007-08-01 23:59:59';

Or you can use BETWEEN too

SELECT * FROM `mydatatable` WHERE date_time BETWEEN  '2007-08-01 00:00:00' AND '2007-08-01 23:59:59';

I am assuming date_time data type is datetime or timestamp.

[kamill]

Try this query

SELECT * FROM `mydatatable` WHERE `date_time` >= '2007-08-01 00:00:00' AND `date_time` <= '2007-08-01 23:59:59';

Or you can use BETWEEN too

SELECT * FROM `mydatatable` WHERE date_time BETWEEN  '2007-08-01 00:00:00' AND '2007-08-01 23:59:59';

I am assuming date_time data type is datetime or timestamp.

Thank You mwasif, Now i am able to generate accurate reports.