Datetime should be Timestamp_ntz

[Ajith-Raja]

django-snowflake/django_snowflake/base.py

Line 32 in 25c6034

'DateTimeField': 'TIMESTAMP_LTZ',

timestamp_ltz is converting the time and inserting, whereas timestamp_ntz inserts the time as it is, so better use timestamp_ntz. Is there any reason in using timestamp_ltz.

[timgraham]

TIMESTAMP_LTZ is used for Django's time zone support (9461268).

Are you encountering a specific problem?

[Ajith-Raja]

Yes is is something like converting the passed datetime to other timezone when inserting

[Ajith-Raja]

so we are dropping the column and creating with timestamp_ntz manually

can you pls check with TIMESTAMP_NTZ

[timgraham]

Django's time zone support isn't possible with TIMESTAMP_NTZ. Can you provide a minimal sample Django project with a failing test case that demonstrates your problem? Django's own test suite has many time zone tests and they are all passing with the current implementation.

[Ajith-Raja]

https://docs.snowflake.com/en/sql-reference/data-types-datetime

just saw the doc TIMESTAMP_LTZ internally stores UTC time with a specified precision

[timgraham]

If you think there's a bug, please include steps to reproduce it.

Closing as invalid.