Bad timestamp external representation
От | Mark Tessier |
---|---|
Тема | Bad timestamp external representation |
Дата | |
Msg-id | 20030428164554.6165d41b.m_tessier@sympatico.ca обсуждение исходный текст |
Ответы |
Re: Bad timestamp external representation
|
Список | pgsql-general |
Hi, When I try to insert with the "current" constant, as in: herboris=> INSERT INTO cart (cartid, clientid, invdate, paydate) VALUES herboris-> (4469858, 2, 'current_timestamp', 'now'); I get the following message: ERROR: Bad date external representation 'current_timestamp' This is how my table is set up: /* -------------------------------------------------------- Table structure for table "cart" -------------------------------------------------------- */ CREATE TABLE "cart" ( "cartid" int8 NOT NULL, "clientid" varchar(8) NOT NULL, "packnum" varchar(20), "shipcost" numeric(5,2), "prepinit" varchar(2), "order_by" varchar(12), "paytype" varchar(20), "invdate" date NOT NULL, "paydate" date, CONSTRAINT "cart_pkey" PRIMARY KEY ("cartid") ); GRANT ALL ON "cart" TO "apache"; GRANT ALL ON "cart" TO "mark"; ALTER TABLE "cart" ALTER COLUMN "invdate" SET DEFAULT 'now'; I changed "paytype" to type "timestamp" and that didn't work either. Could someone please tell me what "Bad external representation"means, and hopefully what I'm doing wrong. -- Thanks, Mark
В списке pgsql-general по дате отправления: