id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
2625	TIME_ZONE setting inadequate behaviour	bakaras@…	Adrian Holovaty	"I have a model with a 'datetime' field and its auto_now_add argument set on. In settings.py of my project I have TIME_ZONE = 'Europe/Moscow'. So, when I create a new object of that model the value of that datetime field is 3 ours decreased.

For example, if now is '30 aug 2006 14:00:00' and I executed test1=My_Model(), then after executing test1.save() result of query:


{{{
    set time zone 'Europe/Moscow';
    select my_datetime_field from my_project_my_model;
}}}

will return '30 aug 2006 11:00:00'

P.S. I use Postgres 8.1 as DBMS.
P.P.S. Sorry for my English."	defect	closed	Database layer (models, ORM)	0.95	normal	worksforme	time_zone, datetime		Unreviewed	0	0	0	0	0	0