querying a db between 2 selected dates...

[Brad]

Hey guys!
Question for ya. How would I approach selecting rows from a database that fall between two user selected dates? I've been looking at date conversions but am not sure what format dates need to be in to be able to do the math on. Any suggestions on how to do/approach this would be a great help!

[kevinsequeira]

well i store the date variable say order_date in my db table as
variable name|type|default
order_date | date| 0000-00-00 ie(yyyy-mm-dd)

and when i do a search i do this

select * from orders where order_date >= '2003-01-01' AND order_date <= '2003-05-30' ;

reg
kevin

[Brad]

Great!

Thanks a lot!

[stolzyboy]

you could always use between also, snippet from mysql.com below

expr BETWEEN min AND max 
If expr is greater than or equal to min and expr is less than or 
equal to max, BETWEEN returns 1, otherwise it returns 0. This is 
equivalent to the expression (min <= expr AND expr <= max) if all 
the arguments are of the same type. Otherwise type conversion 
takes place, according to the rules above, but applied to all the 
three arguments. Note that before 4.0.5 arguments were 
converted to the type of expr instead. 

mysql> SELECT 1 BETWEEN 2 AND 3;
        -> 0
mysql> SELECT 'b' BETWEEN 'a' AND 'c';
        -> 1
mysql> SELECT 2 BETWEEN 2 AND '3';
        -> 1
mysql> SELECT 2 BETWEEN 2 AND 'x-3';
        -> 0
expr NOT BETWEEN min AND max 
Same as NOT (expr BETWEEN min AND max). 

[Brad]

Thanks for all the help guys!