It's for mysql it still does not work. I tried it with the following sql statement "SELECT * FROM project_project WHERE start_date LIKE '%s'" % '2010%%'
On Dec 3, 9:04 am, wayne <[email protected]> wrote: > On Dec 3, 10:47 am, owidjaya <[email protected]> wrote: > > > It says incorrect date value. > > What database are you using? I'm wondering if this is an issue of > formatting the sql correctly. Did you read the snippet near the > bottom of the page I linked to? Try: > > SELECT * FROM some_table WHERE some_date LIKE "%s" % '2010%' -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

