id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 3260 inserting date filed value into MySQL satya sunkara Adrian Holovaty "Hi , We are inserting Date field into a MySQL database using a Django form. Since the form field returns a string representation of Date we are doing the following conversion in our view. t1=strptime(request.POST['startdate'],""%Y-%m-%d"") t2=strftime(""%Y-%m-%d"",t1) and then invoking the model like this p = project.objects.create(entity_id=e.id,name=request.POST['project_name'],description=request.POST['Description'],startdate=t2,acronym=request.POST['acronym']) We are getting the following error*** AttributeError at /startapp/saveproject/ 'str' object has no attribute 'strftime' Request Method: POST Request URL: http://127.0.0.1:8000/startapp/saveproject/ Exception Type: AttributeError Exception Value: 'str' object has no attribute 'strftime' Exception Location: C:\WorkArea\Python24\lib\site-packages\django-0.95-py2.4.egg\django\db\models\fields\__init__.py in get_db_prep_save, line 451 After googling around I found that this error is similar to the error in Ticket# 2192 The ticket 2192 was fixed ,but it seems you need to fix the line 449 in fields\__init__.py I have temporarily added a following fix at 449 and it worked!!!! if value is not None and settings.DATABASE_ENGINE != 'mysql': if value is not None : value = value.strftime('%Y-%m-%d') return Field.get_db_prep_save(self, value) else: return Field.get_db_prep_save(self, value) " defect closed Core (Other) 0.95 major invalid Unreviewed 0 0 0 0 0 0