SQL datetime2(7) field to Django

Question

I need to rewrite this SQL column to a django model field

DateCreated (datetime2(7), not null)

what does the datetime2(7) exactly translate to? Many thanks in advance!

@iklinac: I think the focus is here what Django model field maps to the `datetim2(7)` — Willem Van Onsem, Jan 06 '21 at 17:28
His question is more in a terms of what datetime2(7) exactly translate to, so not really Django related in my personal opinion. But I can see your angle on it — iklinac, Jan 06 '21 at 17:30

score 3 · Accepted Answer · answered Jan 06 '21 at 17:28

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.

1 Answers1