| Subject | Re: [firebird-support] Firebird timestamp data type.. |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2004-11-16T22:45:59Z |
At 05:39 PM 11/16/2004, Goutam Paruchuri wrote:
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.
Regards
Ann
>Iam converting mysql to Firebird.That's one of the unique qualities of MySQL - their casual attitude
>In mysql i have the default timestamp as 0000-00-00 00:00:00'
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.
Regards
Ann