Re: [Zope] Dates off by one day

2006-02-27 Thread Dennis Allison
It is likely to be a problem with timezones. Zope recognizes one particular date format as UTC and not local. If that sounds like the problem, I can provide a patch. On Sat, 25 Feb 2006, Kevin Carlson wrote: Recently moved to a new server farm and am having a problem with dates from

Re: [Zope] Dates off by one day

2006-02-25 Thread Kevin Carlson
Turns out that the times and timezones are the same on all machines. In doing some other reading online I discovered an email where same thing was happening with PostgreSQL. The other interesting thing is that MySQL DATE columns are displayed as one day earlier but MySQL DATETIME columns are

Re: [Zope] Dates off by one day

2006-02-25 Thread Lennart Regebro
On 2/25/06, Kevin Carlson [EMAIL PROTECTED] wrote: Turns out that the times and timezones are the same on all machines. In doing some other reading online I discovered an email where same thing was happening with PostgreSQL. The other interesting thing is that MySQL DATE columns are

[Zope] Dates off by one day

2006-02-24 Thread Kevin Carlson
Recently moved to a new server farm and am having a problem with dates from MySQL that are rendered using strftime. The date in MySQL is correct (e.g. 2005-01-22) but if the date is rendered with strftime the date displayed is one day earlier (e.g., 2005-01-21). MySQL and Zope are on

Re: [Zope] Dates off by one day

2006-02-24 Thread Andrew Milton
+---[ Kevin Carlson ]-- | Recently moved to a new server farm and am having a problem with dates | from MySQL that are rendered using strftime. The date in MySQL is | correct (e.g. 2005-01-22) but if the date is rendered with strftime the | date displayed is one day