[Radiant] Archives by Month??? PROBLEM FOUND, NOW WHAT?

John W. Long ng at johnwlong.com
Fri Aug 11 00:06:10 CDT 2006


Andrew Barnett wrote:
> BUT, STRFTIME('%m' returns a character value, such as '06', whereas  
> it's being compared to the integer 6. I tested in sqlite3 and no rows  
> returned. Wow, 17 years of Oracle experience counts for something in  
> this Web world.
> 
> So, strftime needs to be wrapped with a string-to-integer conversion,  
> yes?

That sounds fine to me. Can you or someone else get me a unit test that 
reproduces the problem? Maybe even a patch that fixes it?

--
John Long
http://wiseheartdesign.com



More information about the Radiant mailing list