Postgres Pro
Downloads
Home   >   mailing lists

DATESTYLE and 0000-00-00 - Mailing list pgsql-sql

From Joshua Kramer
Subject DATESTYLE and 0000-00-00
Date
Msg-id Pine.LNX.4.63.0510060900120.11396@localhost.localdomain
Whole thread Raw
Responses Re: DATESTYLE and 0000-00-00  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Re: DATESTYLE and 0000-00-00  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: DATESTYLE and 0000-00-00  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Dmitri Bichko"
Date:
Subject: Re: UNION index use help
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: DATESTYLE and 0000-00-00