Обсуждение: date column

Поиск
Список
Период
Сортировка

date column

От
Stanimir Stanev
Дата:

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

Вложения

Re: [SQL] date column

От
George Moga
Дата:
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