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(at)flex(dot)ro
Braila, ROMANIA