Thread: date column

date column

From

Stanimir Stanev

Date:

05 February 1999, 09:05:57

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

vcard.vcf

Re: [SQL] date column

From

George Moga

Date:

05 February 1999, 09:32:12

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