On Thu, 2008-06-19 at 02:49 -0400, Drew Jensen wrote: > Keith Clark wrote: > > I seem to have a problem with a timestamp field and mySQL. When I view > > the table it says "Cannot convert timestamp" > > > > What to do? > > > > Well - with just that to go on I would say look at the option > zeroDateTimeBehavior for the JDBC driver. > The MySQL documentation covers this - in brief, MySQL allows a > timestanmp to consist of all zeros ( not all DBMS do that ) > Base does not support this - so you need to tell the driver to convert > such a field value to a NULL. > > The specific reference is located at > http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html > > In your Base file you add this with > Edit > Database > properties > On the Advanced Properies tab first field "Name of the MySQL database" > use standard JDBC syntax to add this. > > For instance if you database is named "kclark" the property would hold > kclark?zeroDateTimeBehavior=convertToNull > > HTH > > Drew
Thanks Drew! Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
