#9275: ORA-01830 date format picture ends before converting entire input...
admin
-------------------------------------+-------------------------------------
Reporter: hollerith | Owner: nobody
Type: | Status: closed
Uncategorized | Component: Database layer
Milestone: | (models, ORM)
Version: 1.0 | Severity: Normal
Resolution: fixed | Keywords: oracle date formats
Triage Stage: | Has patch: 1
Unreviewed | Needs tests: 0
Needs documentation: 0 | Easy pickings: 0
Patch needs improvement: 0 |
UI/UX: 0 |
-------------------------------------+-------------------------------------
Changes (by anurag.chourasia@…):
* ui_ux: => 0
* type: => Uncategorized
* severity: => Normal
* easy: => 0
Comment:
If the issue still persists and 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/9275#comment:4>
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.
