Re: [SQL] date column - Mailing list pgsql-sql

From George Moga
Subject Re: [SQL] date column
Date
Msg-id 36BAD62E.3C923B52@flex.ro
Whole thread Raw
In response to date column  (Stanimir Stanev <stancho@macropoint.com>)
List pgsql-sql
Stanimir Stanev wrote:
 

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

Use:

INSERT INTO test VALUES ('02/02/1999');
                 ^^^^^^^

-- 
Best,
  George Moga,
  george@flex.ro
  Braila, ROMANIA

pgsql-sql by date:

Previous
From: Stanimir Stanev
Date:
Subject: date column, excuse me
Next
From: Patrik Kudo
Date:
Subject: function returning multiple rows?