#11333: ORA-01830 date format picture ends before converting entire input
-------------------------------------+-------------------------------------
Reporter: jtiai | Owner: nobody
Type: | Status: closed
Uncategorized | Component: Database layer
Milestone: 1.3 | (models, ORM)
Version: SVN | Severity: Normal
Resolution: wontfix | Keywords: oracle date formats
Triage Stage: Accepted | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Changes (by anurag.chourasia@…):
* ui_ux: => 0
* type: => Uncategorized
* severity: => Normal
* easy: => 0
Comment:
If the model field is a DateTimeField and the Database field is of DATE
Type then you could try this to overcome this error
Look for the statement where you are updating the Date field. Over there,
replace the microseonds to Zero and Oracle will start treating it
gracefully.
For example, if you model field is called date_field
and if you are updating it as
date_field=datetime.datetime.now()
then change it to
date_field=datetime.datetime.now().replace(microsecond=0)
And that will solve the issue
Regards
Guddu
--
Ticket URL: <https://code.djangoproject.com/ticket/11333#comment:6>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" 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-updates?hl=en.
