Received: from water2.cs.umass.edu (water2.cs.umass.edu [128.119.40.165]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA18708; Thu, 1 Jul 1999 16:48:54 -0400 (EDT) (envelope-from clynch@water2.cs.umass.edu) Received: (from clynch@localhost) by water2.cs.umass.edu (8.8.8/8.8.7) id QAA01725; Thu, 1 Jul 1999 16:48:53 -0400 (EDT) Date: Thu, 1 Jul 1999 16:48:53 -0400 (EDT) From: "Collin F. Lynch" Message-Id: <199907012048.QAA01725@water2.cs.umass.edu> To: pgsql-interfaces@postgresql.org Subject: Time and microseconds? Cc: pgsql-hackers@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-MD5: Db0LN+oyOPnCSAY9mmdqsw== Greetings: I'm having the peculiar problem That Postgres Seems unable to deal with microseconds in a time field. I have the field defined as type time, and postgres accepts input of the form 12:22:13.41 but appears to ose the microseconds withn the database itself? Is there some style variable that must be set, or have I simply missed something in the documentation? Thanks for your help in advance. Collin Lynch.