Received: from rhea.arexim.ro (root@mail.arexim.ro [193.230.225.5]) by hub.org (8.9.2/8.9.1) with ESMTP id GAA18145 for ; Fri, 5 Feb 1999 06:31:59 -0500 (EST) (envelope-from george@flex.ro) Received: from arexim.arexim.ro (root@arexim.arexim.ro [193.230.225.2] (may be forged)) by rhea.arexim.ro (8.9.0/8.9.0) with ESMTP id OAA03023; Fri, 5 Feb 1999 14:25:50 +0200 Received: from flex.ro ([193.230.255.93]) by arexim.arexim.ro (8.7.5/8.7.3) with ESMTP id OAA02363; Fri, 5 Feb 1999 14:32:00 +0200 Sender: gestoc@arexim.ro Message-ID: <36BAD62E.3C923B52@flex.ro> Date: Fri, 05 Feb 1999 13:29:51 +0200 From: George Moga X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.2.0 i586) MIME-Version: 1.0 To: Stanimir Stanev , SQL PostgreSQL Subject: Re: [SQL] date column References: <36BAD0BC.200C308C@macropoint.com> Content-Type: multipart/alternative; boundary="------------C6C63B0B89AC09ED41AF8E9F" --------------C6C63B0B89AC09ED41AF8E9F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------C6C63B0B89AC09ED41AF8E9F Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------C6C63B0B89AC09ED41AF8E9F--