Re: Blank date field.. Help...

Unless you have stated NOT NULL in your table definition, you should be
able to enter NULL's. If you have stated NOT NULL, you'll need to
recreate the table.

CREATE TABLE "nulldatetest" (
   "withnull" date,
   "withoutnull" date NOT NULL
);

INSERT INTO "nulldatetest" ("withnull", "withoutnull") VALUES (NULL,
'2002-07-17')

Robert Treat

On Wed, 2002-07-17 at 09:30, ryan@fdcsmail.darktech.org wrote:
> Hi,
>   Is there any way that I can do, just to make my date columns to accept null/blank
>   values? I use the latest stable version.
>
> Ryan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster