Blank date field.. Help...
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
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
Show quoted text
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