| Subject | Re: Firebird timestamp data type.. |
|---|---|
| Author | GrumpyRain |
| Post date | 2004-11-16T22:37:24Z |
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.
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.