Postgres Pro
Downloads
Home   >   mailing lists

Re: How to setup default value "0000-00-00" for "date" type under PostgreSQL? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: How to setup default value "0000-00-00" for "date" type under PostgreSQL?
Date
Msg-id 20040820083311.D598@hermes.hilbert.loc
Whole thread Raw
In response to How to setup default value "0000-00-00" for "date" type under PostgreSQL?  (Emi Lu <emilu@cs.concordia.ca>)
List pgsql-general
Tree view 
> I really
> want to know how I can save '0000-00-00' as the default value for "date"
> and "timestamp" types.
You can not. They are invalid dates.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Hunter Hillegas
Date:
Subject: Re: Postgres and JBOSS
Next
From: Christian Kratzer
Date:
Subject: Re: How to setup default value "0000-00-00" for "date"