Hi Alessandro, all !
Baron Schwartz wrote:
Hello Allesandro,
Alessandro Agostini wrote:
[[...]]
Watching the table content, I see second record as:
032100, '2005-03-27 03:00:00', 0, '400000.00', '0.000', '0.000', 0,
'0.00'
MySql change the time information of DATAORA field from "02:00:00" to
"03:00:00".
This error is reproducible on various version of mysql. I have tried
it on 3.23, 4.1, 5.0
I can't reproduce this on version 5.0.38 or 5.0.24. Perhaps it is
something to do with the server timezone, the connection timezone, or
the combination of the two?
In 2005, March 27 was a Sunday, the last one in March.
On this day at 02:00, summer time started in (at least: western) Europe,
so '2005-03-27 02:00:00' and '2005-03-27 03:00:00' are really the same
moment in Italian time (which I assume your machines are running on).
HTH,
Jörg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
