db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vignesh Swaminathan" <vswam...@cordys.com>
Subject RE: Two errors with create/alter database SQL in PostgreSQL 8.1
Date Wed, 15 Feb 2006 09:19:17 GMT

"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`)


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.

View raw message