Hi to all,
I have a strange error on using of timestamp data type.
See the follow table definition and insert command.
DROP TABLE IF EXISTS Storicocorrenti;
CREATE TABLE Storicocorrenti (
ID_LINEA mediumint(6) unsigned zerofill NOT NULL default '00',
DATAORA timestamp NOT NULL default
Hello Allesandro,
Alessandro Agostini wrote:
Hi to all,
I have a strange error on using of timestamp data type.
See the follow table definition and insert command.
DROP TABLE IF EXISTS Storicocorrenti;
CREATE TABLE Storicocorrenti (
ID_LINEA mediumint(6) unsigned zerofill NOT NULL default
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, '40.00', '0.000', '0.000', 0,
'0.00'
MySql change the time information of DATAORA field from 02:00:00
@lists.mysql.com
Subject: problem with timestamp data type
Hi to all,
I have a strange error on using of timestamp data type.
See the follow table definition and insert command.
DROP TABLE IF EXISTS Storicocorrenti;
CREATE TABLE Storicocorrenti (
ID_LINEA mediumint(6) unsigned zerofill NOT NULL