Subject Re: [firebird-support] Firebird timestamp data type..
Author Ann W. Harrison
At 05:39 PM 11/16/2004, Goutam Paruchuri wrote:

>Iam converting mysql to Firebird.
>In mysql i have the default timestamp as 0000-00-00 00:00:00'

That's one of the unique qualities of MySQL - their casual attitude
toward datatypes. Most calendar systems consider month zero to be
an out of range value - not, of course, the unix time structure, but
few of us make plans for the 0th of the month and for most of us,
January is month 1, not month zero.

Use a legal date value as your default, or null. The system
base data is 17 November 1858.