Received: from smtp3.mindspring.com (smtp3.mindspring.com [207.69.200.33]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA57698; Wed, 23 Jun 1999 15:06:58 -0400 (EDT) (envelope-from bkruger@mindspring.com) Received: from oplsrv3 (user-38h1ss4.dialup.mindspring.com [209.16.243.132]) by smtp3.mindspring.com (8.8.5/8.8.5) with SMTP id PAA21392; Wed, 23 Jun 1999 15:06:49 -0400 (EDT) Message-Id: <3.0.5.32.19990623140654.007d9d60@mindspring.com> X-Sender: bkruger@mindspring.com (Unverified) X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Wed, 23 Jun 1999 14:06:54 -0500 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org From: Bob Kruger Subject: Date time insertion Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" I am trying to insert both the date and the time into a datetime field. If the field datetime in table v1 is dt, then the following successfully inserts the date into the datetime field: insert into v1 (date) values ('19990401') ; However, if I also wanted to retain the time of day, the following does not work: insert into v1 (date) values ('199904011530') ; Any hints? Thanks in advance. Regards - Bob Kruger