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 Fri, Dec 3, 2010 at 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<django-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- 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.
