FWIW, I think you just need to wrap the STRFTIME in a CAST:
CAST(STRFTIME('%m', published_at) AS INTEGER)
But I'm still just playing around so no hurry to fix from my
perspective.
andrew
On 12/08/2006, at 12:00 AM, John W. Long wrote:
> Andrew Barnett wrote:
>> I can't do a proper Rails unit test, because I've yet to even write
>> my hello-world Rails app...
>>
>> All I can do is tell you what I did, which is to run Radiant under
>> sqlite3 and mongrel on OS X 10.4.
>>
>> Sorry.
>
> Not a problem. If someone else could verify this that would be
> great. If
> not, I'll get to it when I get to it. :-)
>
> --
> John Long
> http://wiseheartdesign.com
> _______________________________________________
> Radiant mailing list
> [email protected]
> http://lists.radiantcms.org/mailman/listinfo/radiant
_______________________________________________
Radiant mailing list
[email protected]
http://lists.radiantcms.org/mailman/listinfo/radiant
