"Ying Lu" <ying_lu(at)cs(dot)concordia(dot)ca> wrote:
>
> I have a question about "date" & "timestamp" types in PostgreSQL. I want
> to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for
> them. However, it seems that PostgreSQL does not support it. Could
> someone helps me please?
if you want to store invalid dates and timestamps, you
are better off using varchar.
if you just want to store a null-value, use NULL
does mysql really allow you to store these values?
gnari