date column - Mailing list pgsql-sql

From Stanimir Stanev
Subject date column
Date
Msg-id 36BAD0BC.200C308C@macropoint.com
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: Maarten Boekhold
Date:
Subject: Re: [SQL] Has every postgreSQL database own users?
Next
From: Stanimir Stanev
Date:
Subject: date column, excuse me