Subject Re: Firebird timestamp data type..
Author GrumpyRain
Hi Goutam,

The date component of the Timestamp '0000-00-00 00:00:00' is not valid
in Firebird.

There is no month 0, and no month has a day 0. Also, I think it went
straight from 1BC to 1AD, so there may not even be a year 0.

You might want to think of a different date to store as your default.
You could use null BUT not if you need an index on that field.
Otherwise, I personally use the date 1/1/0001 to mean the start,
because all the timestamp data in our program are from the past 5
years so it doesn't interfere.