Date and timezone problem

[Rolf Leggewie]

Hi,

I have entered a transaction for July 1st.  This is what it looks like 
in the XML file.

<trn:date-posted>
   <ts:date>2008-07-01 00:00:00 +0200</ts:date>
</trn:date-posted>

When I save that in the SQL backend, it becomes 20080630220000.  Now 
when I run a quarterly report on the SQL database, that transaction is 
counted for the second quarter when it should have been counted in the 
third.

Anybody have an idea how things turned out the way they did?

Regards

Rolf