Menu

#12 'Timestamp' field get translated into 'datetime'

open
core (13)
5
2004-08-06
2004-08-06
Bart
No

When I have the following table:

CREATE TABLE `atable` (
`THEKEYFIELD` int(5) NOT NULL auto_increment,
`SOMETIMESTAMPFIELD` timestamp(14) NOT NULL,
PRIMARY KEY (`THEKEYFIELD`)
) TYPE=MyISAM;

and run it through the Extract/Parse/Execute routines,
the adodb-xmlschema creates the following table:

CREATE TABLE atable (
THEKEYFIELD INTEGER(5) NOT NULL AUTO_INCREMENT,
SOMETIMESTAMPFIELD DATETIME(14),
PRIMARY KEY (THEKEYFIELD)
);

As you can see, the timestamp(14) field is translated
into a datetime(14) field, which creates an error when
I try to use this SQL in MySQL.

Discussion


Log in to post a comment.