I have searched for this, and could not find any notes or tutorials.
Asked
Active
Viewed 2.0k times
1 Answers
24
When you set USE_TZ = True(see USE_TZ for more info) in your settings, Django stores date and time information in UTC in the database otherwise it will store naive date time (date time without timezone).
The default settings.py file created by django-admin startproject includes USE_TZ = True for convenience.
So you have to set USE_TZ = False in your settings to avoid attaching timezone.
NOTE: However you cannot detach timezone only for a particular field. By following my suggestion above, you detach timezone from the entire database, so my guess is that it's better to use a CharField to store date without timezone.
You can try to override the default save handler and remove the timezone from DatetimeField before saving the item into the database, by defining a save method for your model:
def save(self, *args, **kwargs):
self.datetime_field = self.datetime_field.replace(tzinfo=None)
super(MyModel, self).save(*args, **kwargs)
David
- 567
- 4
- 16
Andriy Ivaneyko
- 20,639
- 6
- 60
- 82
-
Which is the default, I believe. – mehmetminanc Mar 09 '16 at 06:45
-
@Andriy I want the date and time format this way '2016-03-09 6:51:43.195486' – Sagar Mar 09 '16 at 06:53
-
@Andriy I use query to insert into the table (not using django ORM) , any python functions would do for me. – Sagar Mar 09 '16 at 06:57
-
@Sagar well, try to replace tz_info to None before saving it, `datetime_field = datetime_field.replace(tzinfo=None) ` – Andriy Ivaneyko Mar 09 '16 at 07:08
-
2@Andriy , This is working fine . But in database (postgresql) we get time stamp with timezone , that need to be like ' time stamp without timezone' , Anything under migrations only not from outside migrations – Sagar Mar 09 '16 at 07:49
-
`save` should not return the object – nivcaner Oct 07 '18 at 07:58