Page 1 of 1
Sql querry for retreiving data using start date and end date
Posted: Fri Aug 14, 2009 12:25 am
by sobha
Hi
Sql querry for retreiving data using start date and end date
Regards
Re: Sql querry for retreiving data using start date and end date
Posted: Fri Aug 14, 2009 1:11 am
by susrisha
Code: Select all
SELECT * FROM `yourtable` WHERE recordDate BETWEEN 'startdate' AND 'endDate';
eg:
Code: Select all
SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31'
Re: Sql querry for retreiving data using start date and end date
Posted: Fri Aug 14, 2009 1:48 am
by neuroxik
susrisha wrote:Code: Select all
SELECT * FROM `yourtable` WHERE recordDate BETWEEN 'startdate' AND 'endDate';
eg:
Code: Select all
SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31'
I was gonna answer him but seeing he almost asks as if "cook my dinner and shut up"... bah, people want help without even providing effort.