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
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2004-06-30 03:03:42|
|Subject: Re: SPI problem |
|Previous:||From: Darko Prenosil||Date: 2004-06-29 22:54:46|
|Subject: Re: SPI problem|