Re: [Django] #9275: ORA-01830 date format picture ends before converting entire input... admin

[Django]

#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: 
Django 
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 django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #9275: ORA-01830 date format picture ends before converting entire input... admin

[Django]

#9275: ORA-01830 date format picture ends before converting entire input... 
admin
---+
  Reporter:  hollerith | Owner:  nobody 

Status:  new   | Milestone: 

 Component:  Database layer (models, ORM)  |   Version:  1.0

Resolution:|  Keywords:  oracle 
date formats
 Stage:  Unreviewed| Has_patch:  1  

Needs_docs:  0 |   Needs_tests:  0  

Needs_better_patch:  0 |  
---+
Changes (by mboersma):

 * cc: ikelly, mboersma (added)

-- 
Ticket URL: 
Django 
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 django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #9275: ORA-01830 date format picture ends before converting entire input... admin

[Django]

#9275: ORA-01830 date format picture ends before converting entire input... 
admin
---+
  Reporter:  hollerith | Owner:  nobody 

Status:  new   | Milestone: 

 Component:  Database layer (models, ORM)  |   Version:  1.0

Resolution:|  Keywords:  oracle 
date formats
 Stage:  Unreviewed| Has_patch:  1  

Needs_docs:  0 |   Needs_tests:  0  

Needs_better_patch:  0 |  
---+
Changes (by hollerith <[EMAIL PROTECTED]>):

  * needs_better_patch:  => 0
  * needs_tests:  => 0
  * needs_docs:  => 0

Comment:

 Both files are the same:

 429c429
 < cursor.execute("ALTER SESSION SET NLS_DATE_FORMAT = '-
 MM-DD' "
 ---
 > cursor.execute("ALTER SESSION SET NLS_DATE_FORMAT = '-
 MM-DD HH24:MI:SS' "

-- 
Ticket URL: 
Django 
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 django-updates@googlegroups.com
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
-~--~~~~--~~--~--~---

[Django] #9275: ORA-01830 date format picture ends before converting entire input... admin

[Django]

#9275: ORA-01830 date format picture ends before converting entire input... 
admin
--+-
 Reporter:  hollerith |   Owner:  nobody
   Status:  new   |   Milestone:
Component:  Database layer (models, ORM)  | Version:  1.0   
 Keywords:  oracle date formats   |   Stage:  Unreviewed
Has_patch:  1 |  
--+-
 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).

-- 
Ticket URL: 
Django 
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 django-updates@googlegroups.com
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
-~--~~~~--~~--~--~---