X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4F801D1B345 for ; Tue, 29 Jun 2004 21:05:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08876-02 for ; Wed, 30 Jun 2004 00:05:04 +0000 (GMT) Received: from ms-smtp-02.rdc-kc.rr.com (ms-smtp-02.rdc-kc.rr.com [24.94.166.122]) by svr1.postgresql.org (Postfix) with ESMTP id 49572D1B199 for ; Tue, 29 Jun 2004 21:04:58 -0300 (ADT) Received: from mdirect.markhamdirect.com (CPE-24-160-241-48.wi.rr.com [24.160.241.48]) by ms-smtp-02.rdc-kc.rr.com (8.12.10/8.12.7) with ESMTP id i5U04x9W012259 for ; Tue, 29 Jun 2004 19:04:59 -0500 (CDT) Received: by mdirect.markhamdirect.com (Postfix, from userid 99) id DC65423B76; Tue, 29 Jun 2004 19:06:36 -0500 (CDT) Received: from [127.0.0.1] (unknown [192.168.1.100]) by mdirect.markhamdirect.com (Postfix) with ESMTP id 1196123ACA for ; Tue, 29 Jun 2004 19:06:36 -0500 (CDT) Message-ID: <40E203A9.6000703@markhamdirect.com> Date: Tue, 29 Jun 2004 19:04:57 -0500 From: Greg Markham User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Embedded SQL timestamp Question (ECPG) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/70 X-Sequence-Number: 4998 I'm trying to use embedded SQL to load some tables and I'm having some trouble being able to create timestamps using PGTYPEStimestamp_current routine to create a timestamp before using it in a insert statement. The issue is that the timestamp that gets created is only to the second. I need it to the microsecond. I will use this timestamp as part of the primary key of two tables. Does anyone know how to create a timestamp object (using PGTYPEStimestamp_current or not) that when insert via embedded SQL will create a timestamp out to at least 6 milliseconds (i.e. 2004-06-29 12:59:59.999999)? Thank you in advance for any help, - Greg Markham gmarkham@markhamdirect.com