mysql and DATE format
timmuddletin at news.vex.net
Thu Nov 25 05:56:14 CET 1999
sp00fD at yahoo.com (sp00fD) wrote in <81hhm6$ba2$1 at nnrp1.deja.com>:
>SELECT id, subject, author, text, DATE_FORMAT(date, \"%W, %d %b %Y\"),
Another solution is to double the % characters you don't want
translated by python. So for (just an) example....
>>> "DATE_FORMAT(%s, \"%%W, %%d %%b %%Y\")" % 'date'
'DATE_FORMAT(date, "%W, %d %b %Y")'
Note that only the first %s was translated. All the %% are transleted
to single %.
More information about the Python-list