Saving datefield through django to Postgresql returns format error

Question

I'm trying to save date formatted as dd/mm/yyyy from a view using Django to a postgresql table. I get the following error:

ValidationError: [u"'2014/01/30' value has an invalid format. It must be in YYYY-MM-DD HH:MM[:ss[.uuuuuu]][TZ] format."]

how can i change the format of a specific table or the entire database?

I've tried:ALTER DATABASE myDb SET datestyle TO "ISO, YMD";

then when i run SHOW lc_ctype; i get:

lc_ctype   
-------------
en_US.UTF-8

and SELECT current_date; returns

  date    
------------
 2014-01-29

So it looks good, what raise the question if the error is in Django

my views.py looks like this:

logEntry, created = Logs.objects.get_or_create(entrydate=request_data['entryDate'], message=request_data['message'])
logEntry.save()

and my models.py

class Logs(models.Model):
   entrydate= models.DateTimeField(auto_now_add=True)
   message = models.CharField(max_length=100)

arocks · Accepted Answer · 2014-01-30 07:21:08Z

1

Rather than making changes on the db, I would recommend changing your view so that your date is correctly parsed into a datetime. Additionally, saving it as a timezone aware datetime object can be done as follows:

# views
from django.utils import timezone
from datetime import datetime


entrydt = datetime.strptime(request_data['entryDate'], "%Y/%m/%d")
entrydt = entrydt.replace(tzinfo=timezone.get_current_timezone())
logEntry, created = Logs.objects.get_or_create(entrydate=entrydt, 
                                               message=request_data['message'])
logEntry.save()

answered Jan 30, 2014 at 7:21

arocks

2,8821 gold badge14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cehmja · Accepted Answer · 2014-01-30 00:12:25Z

0

Maybe you have DateTimeField instead DateField in your model. This error message in DateTimeField Change DateTimeField -> DateField

edited Jan 30, 2014 at 0:12

answered Jan 30, 2014 at 0:06

cehmja

1406 bronze badges

1 Comment

cehmja Over a year ago

if it's must in YYYY-MM-DD format then i think '2014/01/30'.replace('/','-'). But it's ugly

Collectives™ on Stack Overflow

Saving datefield through django to Postgresql returns format error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related