View Single Post

   
  #2 (permalink)  
Old 05-10-2008, 03:12 PM
metaperl
 
Posts: n/a
Default Re: optimal selection of all records for a certain month (illegaldates OK?)

On May 8, 2:09 pm, metaperl <metap...@gmail.com> wrote:
> First a simple question: Is it allowed to provide a date range that
> has an illegal date.


No it isn't:

SELECT * FROM fut WHERE last_update_date BETWEEN '2007-09-01' AND
'2007-09-31'; -- ERROR
Reply With Quote