date column

From: Stanimir Stanev <stancho(at)macropoint(dot)com>
To: "pgsql-sql(at)hub(dot)org" <pgsql-sql(at)hub(dot)org>
Subject: date column
Date: 1999-02-05 11:06:36
Message-ID: 36BAD0BC.200C308C@macropoint.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have "test" table:

+-------+-------+-------+
| Field | Type | length|
+-------+-------+-------+
| _date | date | 4 |
|-------+-------+-------+

and i want insert into "test" a row:

test72=> insert into test ('02/02/1999');
ERROR: parser: parse error at or near "'"

how can i insert date into this table?

10x to all
Stanimir

Attachment Content-Type Size
vcard.vcf text/x-vcard 243 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stanimir Stanev 1999-02-05 11:18:01 date column, excuse me
Previous Message Maarten Boekhold 1999-02-05 10:43:15 Re: [SQL] Has every postgreSQL database own users?