Re: DATESTYLE and 0000-00-00

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Joshua Kramer <josh(at)globalherald(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: DATESTYLE and 0000-00-00
Date: 2005-10-06 18:37:45
Message-ID: 20051006183745.GA17388@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 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?

Why do you want to, considering that 0000-00-00 is *not* a valid
date? Why not use NULL to represent an unknown value?

--
Michael Fuhr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hector Rosas 2005-10-06 19:43:33 Selecting records not present in related tables
Previous Message D'Arcy J.M. Cain 2005-10-06 18:16:27 Re: DATESTYLE and 0000-00-00