From stancho@macropoint.com Fri Feb 5 11:05:50 1999 Received: from home.macropoint.com (IDENT:root@nisoft-gw.customer.0rbitel.net [195.24.32.214]) by hub.org (8.9.2/8.9.1) with ESMTP id GAA15255 for ; Fri, 5 Feb 1999 06:05:50 -0500 (EST) (envelope-from stancho@macropoint.com) Received: from macropoint.com ([195.24.34.67]) by home.macropoint.com (8.8.7/8.8.7) with ESMTP id NAA07027 for ; Fri, 5 Feb 1999 13:10:18 +0200 Message-ID: <36BAD0BC.200C308C@macropoint.com> Date: Fri, 05 Feb 1999 13:06:36 +0200 From: Stanimir Stanev Organization: MacroTex www.macrotex.com X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-sql@hub.org" Subject: date column Content-Type: multipart/mixed; boundary="------------E6AB4B93A228E9126FD5E05D" This is a multi-part message in MIME format. --------------E6AB4B93A228E9126FD5E05D Content-Type: multipart/alternative; boundary="------------18A729617C35B79B900AC843" --------------18A729617C35B79B900AC843 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------18A729617C35B79B900AC843 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

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 --------------18A729617C35B79B900AC843-- --------------E6AB4B93A228E9126FD5E05D Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Stanimir Stanev Content-Disposition: attachment; filename="vcard.vcf" 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 --------------E6AB4B93A228E9126FD5E05D-- From george@flex.ro Fri Feb 5 11:31:59 1999 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--