Quick Links

DATESTYLE and 0000-00-00

From:	Joshua Kramer <josh(at)globalherald(dot)net>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	DATESTYLE and 0000-00-00
Date:	2005-10-06 13:01:22
Message-ID:	Pine.LNX.4.63.0510060900120.11396@localhost.localdomain
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

Greetings,

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?

Thanks,
-Josh

Responses

Re: DATESTYLE and 0000-00-00 at 2005-10-06 18:15:12 from Andrew Sullivan
Re: DATESTYLE and 0000-00-00 at 2005-10-06 18:16:27 from D'Arcy J.M. Cain
Re: DATESTYLE and 0000-00-00 at 2005-10-06 18:37:45 from Michael Fuhr

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Russell Simpkins	2005-10-06 13:06:29	Re: Scripting GRANT on functions
Previous Message	Richard Huxton	2005-10-06 12:19:15	Re: Noob question about types and lists