Extra method containing %...

[Stephane]

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

[anonymous]

Sorry, the above code does not work too:

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

[Aymeric Augustin]

Could you describe more specifically what "doesn't work"? If you get an exception, could you paste the traceback?

PS: random suggestion:

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

(with two % — % is the escape character for parameter substitution in Django's ORM, it must be escaped too)