|Subject||Re: [firebird-support] Firebird timestamp data type..|
> Thanks for all the replies.This isn't MySQL. You cannot use a 0000-00-00 default. It doesn't make
> Here is the summary of what I found.
> I can create a table with default of 0000-00-00 00:00:00 for timestamp
> data type column. However all inserts do fail (doesn't matter which
> datetime format I use)..
> I gave the default as 0001-01-01 00:00:00 , the inserts work.. Maybe
> others can confirm this behaviour.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL