sqlite datetime issue with django

48 views
Skip to first unread message

puneet loya

unread,
Sep 25, 2012, 2:19:32 PM9/25/12
to django...@googlegroups.com
Hi,

I m having problems with sqlite insertion.

When i enter datetime object using django into sqlite, sqlite is converting the datetime to UTC and storing it. Hence the datetime inserted in the sqlite db is incorrect.

My timezone in UTC+05:30 and the datetime inserted is in UTC.


Any suggestions??

Bill Freeman

unread,
Sep 25, 2012, 3:05:20 PM9/25/12
to django...@googlegroups.com
When django reads the data back, does it reconvert it to your
timezone? If so, why is it a problem that it is stored as UTC in the
database?
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/django-users/-/98E6x3lnvtwJ.
> To post to this group, send email to django...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.

puneet loya

unread,
Oct 3, 2012, 3:15:53 PM10/3/12
to django...@googlegroups.com
Thank you :) Will check that :)
Reply all
Reply to author
Forward
0 new messages