On Thu, 6 Oct 2005 09:01:22 -0400 (EDT) Joshua Kramer <[EMAIL PROTECTED]> wrote: > I have my DATESTYLE set to ISO MDY. > > When I try to create a table with a default date of 0000-00-00, psql says > that this is an invalid date. Why, and can (or how can I) get it to > accept 0000-00-00 as a valid date?
It is invalid. There was no year 0. Perhaps what you want is NULL or, possibly, EPOCH if you are looking for a sentinel value. -- D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
