Unix Epoch datetime filter

unix_epoch_datetime_filter.py

from datetime import datetime

from django.db import models
from django_filters import FilterSet
from django_filters.filters import Filter

from my_app.models import MyModel  # FIXME

class UnixEpochDateFilter(Filter):
    def filter(self, qs, value):
        if value:
            try:
                # Convert Unix milliseconds epoch to datetime
                converted_date = datetime.fromtimestamp(int(value) / 1000)
            except (ValueError, TypeError):
                return qs.none()

            lookup = "%s__%s" % (self.field_name, self.lookup_expr)
            return qs.filter(**{lookup: converted_date})
        return qs


class MyModelFilter(FilterSet):
    class Meta:
        model = MyModel
        fields = {
            "activated_at": ["lte", "gte"],
            "deactivated_at": ["lte", "gte"],
            "created_at": ["lte", "gte"],
            "updated_at": ["lte", "gte"],
        }
        filter_overrides = {
            models.DateTimeField: {
                "filter_class": UnixEpochDateFilter,
            }
        }