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:

#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

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 !

score 121 · Accepted Answer · answered Apr 16 '13 at 20:31

121

You should use

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.

answered Apr 16 '13 at 20:31

Ngenator

4

I'm ashamed, I thought I had already tried that; I guess I hadn't tried the three arguments at the same time... It's working now, thank you for the help !! – Robin Apr 16 '13 at 20:34
No problem, happens to all of us :) – Ngenator Apr 16 '13 at 20:52
It did not work for me, actually I am adding date field later, there are already some values without date field. – Muhammad Usman Apr 10 '14 at 12:08

1 Answers1