Django model: NULLable field

Question

I'm working on a django project where I need a DateField to sometimes be empty. My model looks like this:

Click to copy

#models.py end = models.DateField(default=None, blank=True) 

But when I run python manage.py sql myapp the sql statement always end up being

Click to copy

CREATE TABLE "myapp_date" ( "end" date NOT NULL ); 

Therefore my field isn't nullable and I can't understand what I should do to make it so. Any idea would be appreciated !

Answer 1

You should use

Click to copy

end = models.DateField(default=None, blank=True, null=True) 

Basically blank allows you to pass it a null value, but null tells the database to accept null values.