<vignesh/>
"Winning solutions find the right balance between market needs and
technical needs"
-----Original Message-----
From: Vignesh Swaminathan
Sent: Wednesday, February 15, 2006 2:49 PM
To: Vignesh Swaminathan
Subject: RE: Two errors with create/alter database SQL in PostgreSQL 8.1
The link given for MySQL says that
"Illegal DATETIME, DATE, or TIMESTAMP values are converted to the "zero"
value of the appropriate type ('0000-00-00 00:00:00' or '0000-00-00'). "
=>The question now is: how is the column defined in the MySql database ?
Could you provide the SQL for the table definition ?
MySQL 5.1 seems to understand and accept that value, this SQL is
generated from the MySQL 5.1 query tool and executes fine. I did not
create this table in MySQL initially but used a SQL script exported from
SQL Server.
DROP TABLE IF EXISTS `testdb`.`cireport`;
CREATE TABLE `testdb`.`cireport` (
`id` int(11) NOT NULL default '0',
`startdate` datetime default '0000-00-00 00:00:00',
`enddate` datetime default '0000-00-00 00:00:00',
`employee` int(11) default '0',
`lead` int(11) default '0',
`rating` int(11) default '0',
`type` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
<vignesh/>
***************************************************************************************************
The information in this message is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this message by anyone else
is
unauthorized. If you are not the intended recipient, any disclosure, copying,
or
distribution of the message, or any action or omission taken by you in reliance
on it is prohibited and may be unlawful. Please immediately contact the sender
if
you have received this message in error. This email does not constitute any
commitment from Cordys Holding BV or any of its subsidiaries except when
expressly agreed in a written agreement between the intended recipient and
Cordys Holding BV or its subsidiaries.
***************************************************************************************************
