Re: [SQL] DATESTYLE and 0000-00-00

2005-10-06 Thread Michael Fuhr
On Thu, Oct 06, 2005 at 09:01:22AM -0400, Joshua Kramer wrote: > I have my DATESTYLE set to ISO MDY. > > When I try to create a table with a default date of -00-00, psql says > that this is an invalid date. Why, and can (or how can I) get it to > accept -00-00 as a valid date? Why do y

Re: [SQL] DATESTYLE and 0000-00-00

2005-10-06 Thread Andrew Sullivan
On Thu, Oct 06, 2005 at 09:01:22AM -0400, Joshua Kramer wrote: > I have my DATESTYLE set to ISO MDY. > > When I try to create a table with a default date of -00-00, psql says > that this is an invalid date. Why, and can (or how can I) get it to > accept -00-00 as a valid date? You can'

Re: [SQL] DATESTYLE and 0000-00-00

2005-10-06 Thread D'Arcy J.M. Cain
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 -00-00, psql says > that this is an invalid date. Why, and can (or how can I) get it to > accept -00-00 as a val

[SQL] DATESTYLE and 0000-00-00

2005-10-06 Thread Joshua Kramer
Greetings, I have my DATESTYLE set to ISO MDY. When I try to create a table with a default date of -00-00, psql says that this is an invalid date. Why, and can (or how can I) get it to accept -00-00 as a valid date? Thanks, -Josh ---(end of broadcast)-