List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:January 8 2000 7:02pm
Subject:Re: Changed since 3.21.31?
View as plain text  
At 5:34 PM +0100 2000-01-08, Dennis Thrysøe wrote:
>Hi,
>
>The following query produces an odd result when run against a mysql version
>3.21.31-log.
>
>SELECT field1, DATE_FORMAT(Start, '%e %b %Y') AS Start, DATE_FORMAT(End, '%e
>%b %Y') AS End FROM table1 WHERE ID = 17
>
>This query delivers a result like:
>
>field1 = somevalue; Start='e Apr 2000'; End = 'e May 2000'
>
>Did the date formatting tokens change since the mentioned version? (This
>query behaves well in my 3.22.28 instance). Or could it be a bug?
>
>Any help appreciated.


My guess is that %e was added as a format specifier sometime after 3.21.31,
because 3.21.31 appears to treat %e as simply e, which is what happens
for any unrecognized specifier.  Try %d and see if that works.

-- 
Paul DuBois, paul@stripped
Thread
Changed since 3.21.31?Dennis Thrysøe8 Jan
  • Re: Changed since 3.21.31?Paul DuBois8 Jan
    • RE: Changed since 3.21.31?Dennis Thrysøe8 Jan
  • Re: Changed since 3.21.31?Sinisa Milivojevic9 Jan