RE: Inclusive/Exclusive confusion for BETWEEN operator

[Fred Lindberg]

On Mon, 31 May 1999 13:23:30 -0700, Jeff Magnusson wrote:

>select date_format(submission,'%Y-%m-%d') as df,count(*) from addresses
>group by df having df between '1999-05-01' and '1999-05-31'

This is expensive. It's probably cheaper to make the field a DATE (or
to have one of each):

select submission_date, count(*) from addressses
	where submission_date between '1999-05-01' and '1999-05-31'
	group by submission_date


-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)