Thread: Embedded SQL timestamp Question (ECPG)

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

Just use a double, e.g. something along the lines of:
EXEC SQL BEGIN DECLARE SECTION;double l_tstamp;EXEC SQL END DECLARE SECTION;
l_tstamp =  (double)seconds;l_tstamp += (double)microsecs / 1000000.0;
EXEC SQL INSERT INTO table(column) VALUES(:l_tstamp);

Watch out for timezones...

Greg Markham writes:> I'm trying to use embedded SQL to load some tables and I'm having some > trouble being able to
createtimestamps 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
thistimestamp as > part of the primary key of two tables.  Does anyone know how to create a > timestamp object (using
PGTYPEStimestamp_currentor 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