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.