On Oct 10, 1:08 am, dusans <[EMAIL PROTECTED]> wrote: > Im getting this error when updating or inserting a row with a DateTime > Field. Did i do something wrong or is it a bug? Same error in admin > console also. > > ERROR: > ORA-01830: date format picture ends before converting entire input > string > > Django SQL: > UPDATE "IFS_UIFN_SLO_TUJ" SET > "DATUM_VKLJUCITVE" = 2008-08-13 00:00:00, > "DATUM_IZKLJUCITVE" = 2008-08-15 00:00:00, > "TS" = 2008-08-12 11:59:39.566847 > > Django Model: > class IfsUifnSloTuj(models.Model): > datum_vkljucitve = models.DateTimeField(null=True, > db_column='DATUM_VKLJUCITVE', blank=True) > datum_izkljucitve = models.DateTimeField(null=True, > db_column='DATUM_IZKLJUCITVE', blank=True) > ts = models.DateTimeField(null=True, db_column='TS', blank=True) > class Meta: > db_table = u'IFS_UIFN_SLO_TUJ'
This would happen if the Oracle type of the datum_* columns is DATE rather than TIMESTAMP. If that's the case, you need to represent those columns in your model using DateField rather than DateTimeField (inspectdb does the wrong thing here). Hope that helps, Ian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@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-users?hl=en -~----------~----~----~----~------~----~------~--~---
