List:General Discussion« Previous MessageNext Message »
From:tony Date:August 10 1999 8:44am
Subject:Actually: BUG with DISTINCT and ORDER on dates
View as plain text  
Further to my last message, I have discovered it's the ORDER BY that seems
to cause the problem:

select distinct date_format(when, "ymd") from testsale order by when;
+--------------------------+
| date_format(when, "ymd") |
+--------------------------+
| 990808                   |
| 990808                   |
| 990809                   |
| 990809                   |
| 990809                   |
| 990810                   |
| 990810                   |
| 990810                   |
+--------------------------+


Tony
-- 
-----------------------------------------------------------------------------
 Tony Bowden | tony@stripped               http://www.blackstar.co.uk/
  Black Star |    The UK's Biggest Video & DVD store * Free Postage Worldwide
-----------------------------------------------------------------------------
Thread
Actually: BUG with DISTINCT and ORDER on datestony10 Aug
  • Re: Actually: BUG with DISTINCT and ORDER on datesMartin Ramsch10 Aug
    • Re: Actually: BUG with DISTINCT and ORDER on datesMichael Widenius17 Aug