Hello list I found a little problem with an application am developing, in particular creating reports by DATE ranges.
Examples: select ... where date>"2007-01-01"; returns all records where date is greater (and equal inclusive) to 2007-01-01 select ... where date>="2007-01-01"; returns all records where date is greater/equal to 2007-01-01 the ">" and ">=" have the same effect select ... where date>"2007-01-01" and date<"2007-01-20"; returns all records where date is greater/equal to 2007-01-01 and less than "2007-01-20" *** DOES NOT RETURN RECORDS FROM DAY *20* select ... where date>"2007-01-01" and date<="2007-01-20"; returns all records where date is greater/equal to 2007-01-01 and less than "2007-01-20" although I'm using "<=" *** DOES NOT RETURN RECORDS FROM DAY *20* My doubts are: 1. how can I retrieve rows with a date>"..." NOT INCLUDING the day of the specified date, I mean apply a strict GREATHER THAN 2. how can I retrieve rows with date<="..." INCLUDING the day of the specified date. currently I have to do a date>="date1" and date<="date2+1day" I need to retrieve rows in this way date>X date>=X date<X date<=X date>X and date<Y date>=X and date<Y date>=X and date<=Y date>X and date<=Y and so... didn't find a function to specify ranges of dates and the LESS THAN/EQUAL operator does not include the last day, so my reports with "<=" are done by adding one day but don't like to use it this way since it could be confusing and generate errors on reports. Thanks for any comment, Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
