id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
16889	Extra method containing %...	Stephane	nobody	"I would like to use the MySQL function DATE_FORMAT in Django 1.3.1.

This syntax is the most logical, but does not work:

{{{Upload.objects.extra(select={'year': ""DATE_FORMAT(`date_uploaded`, '%Y')""})}}}

But this works:

{{{Upload.objects.extra(select={'year': ""%s""}, select_params=[""DATE_FORMAT(`date_uploaded`, '%Y')""])}}}

Is this a normal situation?

Best regards,

Stéphane"	Bug	closed	Uncategorized	1.3	Normal	needsinfo			Unreviewed	0	0	0	0	0	0