Django TimeStamp inconsistency?

If this is a live server perhaps you need to check the . Conf files for timestamp settings?

If this is a live server perhaps you need to check the . Conf files for timestamp settings? For example you may find that at /etc/httpd/conf/httpd.

Conf And add the following line setenv TZ America.

This fixed the problem. Thank you! It's weird that the time would be randomly be different each time I refreshed but adding this to httpd.

Conf did fix the problem. – PowerAnimal Oct 21 '11 at 15:30.

Suspiciously sounds like a timezone problem, possibly involving daylight saving time. You are aware of the differences with these types in PostgreSQL? Timestamp timestamp with time zone Note the difference: db=# SELECT '2011-10-20 10:00+1'::timestamp; timestamp --------------------- 2011-10-20 10:00:00 db=# SELECT '2011-10-20 10:00+1'::timestamp AT TIME ZONE '-1'; timezone ------------------------ 2011-10-20 11:00:00+02 You may find a clue in the chapter on time zones.

Converting timestamp columns is simple. To just cut off the timezone part: ALTER TABLE tbl ALTER col TYPE timestamp; To convert all times to a specific timezone, for instance 'UTC': ALTER TABLE tbl ALTER col TYPE timestamp USING col::timestamp AT TIME ZONE 'UTC.

The problem is sometimes when I refresh the page it's an hour off and other times it's correct. Currently I am using the timestamp with time zone type. – PowerAnimal Oct 19 '11 at 19:19 Do you have need for with time zone?

If not you could probably solve your problem by switching to just timestamp. Convert your table columns for that. I'll add some info to my answer.

– Erwin Brandstetter Oct 19 '11 at 20:25.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.