----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 27, 2004 14:30 Subject: Re: Date Range
> I think you are very close but you are missing the LAST day of each month. > I think you need to change your WHERE to read > > WHERE queue_time >= @Start AND queue_time < @BegOfMonth > > Reasoning: If @BegOfMonth is '2004-09-01' then @End will be '2004-08-31'. > If queue_time is a datetime value somewhen during the day of 8/31 (like > '2004-08-31 13:15:46') then you miss it with "< @End". Because of the time > component, you still miss that event if you change the comparator to "<=". > You need to compare to < the next date (@BegOfMonth). > > '2004-08-31 13:15:46' < '2004-08-31' is false > '2004-08-31 13:15:46' <= '2004-08-31' is false > '2004-08-31 13:15:46' < '2004-09-01' is true > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine Shawn, You are correct. It also eliminates any purpose for the @End variable, which is fine. I just tested it and the results were correct. Thanks a lot. It's still Monday! Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters USA Central Time Zone 636-922-9158 ext. 8652 fax 636-447-4471 [EMAIL PROTECTED] www.nisc.cc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
