What's the correct None or null entry for a datetime.datetime object in Python?

Question

I'm loading some dates into mongodb using pymongo. Because pymongo does automatic conversions to BSON, I'm working with datetime's datetime.strptime function to turn input strings like "12/04/2013" into Date objects like so: ``` >>> datetime.datetime.strptime("12/04/2013",'%m/%d/%Y') datetime.datetime(2013, 12, 4, 0, 0) ``` So that they can be searchable using standard mongo queries. My problem is: I would also like to represent that I do not know what date something is in a way equivalent to `None`, so that I can do `None` null-tests on it. I realize I could just put this date very far in the past or future with a try-catch block for entering `''` or `None`, but this is hacky thinking and I'd rather use a proper None-type to represent what is actually a None. How can I enter a None datetime?

Accepted Answer

When you search MongoDB `null` and missing values are equivalent.

```
> db.foo.insert({a: null})
> db.foo.insert({})
db.foo.find({a: null}, {_id: 0})
{ "a" : null }
{  }
```

It works the same way with `pymongo`:

```
>>> [doc for doc in pymongo.MongoClient().test.foo.find({'a': None}, {'_id': 0})]
[{u'a': None}, {}]
```

So `None` seems to be a good choice. It is consistent with Python semantics, it plays nice with default behavior of `dict.get` method and maps intuitively to MongoDB types when using Python driver.

What's the correct None or null entry for a datetime.datetime object in Python?

Solution

Problem