Re: dates in select statement

Programador wrote: > > SELECT field1,field2...fieldn FROM table WHERE field_date > '$initial_date' > AND field_date < '$final_date' > > From: Alaiddin Tayeh <atayeh@p-i-s.com> > > > Hello, > > I would like to make a select statement that use dates in where clause: > > 1- date between tow dates > > 2- where month of the date =$value > > 3- where year of the date =$value Programador is heading the right direction. I'd cange one thing first, to use the between statement. SELECT field1,field2...fieldn FROM table WHERE field_date BETWEEN '$initial_date' AND '$final_date'; Now, we need to take care of your month and year parameters you asked about. I'm guessing you have the date in a DATE field. SELECT field1,field2...fieldn FROM table WHERE (field_date BETWEEN '$initial_date' AND '$final_date') AND field_date = '$year-$month%'; In general, make sure your date field is indexed for speedier performance. Enjoy, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409