Hello, I'm displaying dates retrieved from a MySQL database using: <span tal:content="python: news['Date'].strftime('%d/%m/%Y')">Date</span> In a strange behaviour using strftime is displaying dates with 1 day past, example 10/05/2005 is being show as 09/05/2005. If i change the code to show the date as it comes from MySQL it is correct and if I change the code to not use strftime and manually retrieve .month() .day() .year() it is also correct. My locale in Zope is set to BRT and in console everything works. Zope 2.7 and Pthin 2.3 from debian sarge. Thanks, -- Luiz Fernando B. Ribeiro Engenho Soluções para a Internet +55 11 6959-7610
Luiz Fernando B. Ribeiro wrote:
<span tal:content="python: news['Date'].strftime('%d/%m/%Y')">Date</span>
In a strange behaviour using strftime is displaying dates with 1 day past, example 10/05/2005 is being show as 09/05/2005.
Well, it certainly sounds like a timezone issue, maybe in ZMySQLDA, maybe in DateTime itself. Boil it down to a minimal reproducible test case. If that only involves DateTime, then submit to the Zope collector on Zope.org, if it needs ZMySQLDA to happpen, report the issue in the mysql-python collector on SourceForge... cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
participants (2)
-
Chris Withers -
Luiz Fernando B. Ribeiro