pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddate column
2+ messages / 2 participants
[nested] [flat]
* date column
@ 1999-02-05 11:06 Stanimir Stanev <stancho@macropoint.com>
0 siblings, 1 reply; 2+ messages in thread
From: Stanimir Stanev @ 1999-02-05 11:06 UTC (permalink / raw)
To: pgsql-sql@hub.org <pgsql-sql@hub.org>
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
Attachments:
vcard.vcf (text/x-vcard, 241B) download
begin: vcard
fn: Stanimir Stanev
n: Stanev;Stanimir
email;internet: stancho@macropoint.com
title: software developer
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
version: 2.1
end: vcard
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] date column
@ 1999-02-05 11:29 George Moga <george@flex.ro>
parent: Stanimir Stanev <stancho@macropoint.com>
0 siblings, 0 replies; 2+ messages in thread
From: George Moga @ 1999-02-05 11:29 UTC (permalink / raw)
To: Stanimir Stanev <stancho@macropoint.com>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-02-05 11:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-05 11:06 date column Stanimir Stanev <stancho@macropoint.com>
1999-02-05 11:29 ` George Moga <george@flex.ro>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox