Django

Code

Ticket #9275 (closed: fixed)

Opened 1 year ago

Last modified 1 year ago

ORA-01830 date format picture ends before converting entire input... admin

Reported by: hollerith Assigned to: nobody
Milestone: Component: Database layer (models, ORM)
Version: 1.0 Keywords: oracle date formats
Cc: ikelly, mboersma Triage Stage: Unreviewed
Has patch: 1 Needs documentation: 0
Needs tests: 0 Patch needs improvement: 0

Description

Doing: Porting a legacy application on Oracle 10g. Symptom: The admin change interface reported this error on Datetimefields. Solution:I found the 'works for me' at least was to alter the NLS_DATE_FORMAT in backend/oracle/base.py to include the time in the correct format to match django format (i.e. no fractions).

Attachments

base.diff (186 bytes) - added by hollerith@gmail.com on 10/02/08 15:29:25.
basic diff
base.2.diff (186 bytes) - added by hollerith <sp4me4ter@hotmail.com> on 10/02/08 15:31:40.

Change History

10/02/08 15:29:25 changed by hollerith@gmail.com

  • attachment base.diff added.

basic diff

10/02/08 15:31:40 changed by hollerith <sp4me4ter@hotmail.com>

  • attachment base.2.diff added.

10/02/08 15:34:33 changed by hollerith <sp4me4ter@hotmail.com>

  • needs_better_patch changed.
  • needs_tests changed.
  • needs_docs changed.

Both files are the same:

429c429 < cursor.execute("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD' " ---

cursor.execute("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' "

01/18/09 11:54:24 changed by mboersma

  • cc set to ikelly, mboersma.

01/19/09 14:50:31 changed by ikelly

  • status changed from new to closed.
  • resolution set to fixed.

(In [9780]) [1.0.X] Fixed #9275: Extended the Oracle date format to allow DATE columns to be used with DateTimeFields?, especially when using legacy databases. Thanks to hollerith for the patch. Backport of [9779] from trunk.

Add/Change #9275 (ORA-01830 date format picture ends before converting entire input... admin)




Change Properties
Action