From: Greg Markham <gmarkham@markhamdirect.com>
To: pgsql-interfaces@postgresql.org
Subject: Embedded SQL timestamp Question (ECPG)
Date: Tue, 29 Jun 2004 19:04:57 -0500
Message-ID: <40E203A9.6000703@markhamdirect.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: gmarkham@markhamdirect.com
Subject: Re: Embedded SQL timestamp Question (ECPG)
In-Reply-To: <40E203A9.6000703@markhamdirect.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox