SQL datetime2(7) field to Django

Question

This question already has an answer here: question from:https://stackoverflow.com/questions/65600327/sql-datetime27-field-to-django

Answer 1

If you use the django-mssql-backend package [GitHub], then it is a DateTimeField [Django-doc], based on the source code [GitHub]:

data_types = {
    # ...,
    'DateTimeField': 'datetime2',
    # …
}

This will thus translate to a datetime2 column type, and the default precision is seven [ms-doc]:

Precision, scale, 0 to 7 digits, with an accuracy of 100ns. The default precision is 7 digits.