pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
date column
2+ messages / 2 participants
[nested] [flat]

* date column
@ 1999-02-05 11:06 Stanimir Stanev <stancho@macropoint.com>
  1999-02-05 11:29 ` Re: [SQL] date column George Moga <george@flex.ro>
  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:06 date column Stanimir Stanev <stancho@macropoint.com>
@ 1999-02-05 11:29 ` George Moga <george@flex.ro>
  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