Andrej Falout  wrote:

> Since the beginning of the time...
> 
> Err, why is this OK:
>       default '0001-01-01 00:00:00',
> but this is not?
>       '0000-00-00 00:00:00',

there is no month 0 and no day 0 possible in any case
in a date/timestamp value. Which date should be specified by this?

And as far as we know there was no year 0. Time-calculation started with year 1.
Therefore : the whole date-portion of your 
0000-00-00 00:00:00
is wrong.

If you just want to store time-values, please use the
datatype time, no date/timestamp with 0-date-portion.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to