Hi
Sql querry for retreiving data using start date and end date
Regards
Sql querry for retreiving data using start date and end date
Moderator: General Moderators
Re: Sql querry for retreiving data using start date and end date
Code: Select all
SELECT * FROM `yourtable` WHERE recordDate BETWEEN 'startdate' AND 'endDate';
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
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.susrisha wrote:eg:Code: Select all
SELECT * FROM `yourtable` WHERE recordDate BETWEEN 'startdate' AND 'endDate';Code: Select all
SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31'