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 <wayne.tuxro...@gmail.com> wrote: > On Dec 3, 10:47 am, owidjaya <owidj...@gmail.com> 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 django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.