Re: Timestamp Question

Oliver Jowett wrote:

> Greg Markham wrote:
>
>> I have searched the archives and not found and answer to this question:
>>
>> I am trying to use a Java Timestamp object to create a Postgresql
>> Timestamp(6) field.  I can insert a Timestamp but it only goes to the
>> millisecond(2004-07-10 12:59:59.123) I need it to the microsecond
>> (2004-07-10 12:59:59.123456).  Is there a way to do this?
>
>
> From a quick look at the driver code, it appears to support nanosecond
> precision in Timestamps.
>
> What exactly is the problem you see? Can you provide a testcase?
>
> -O
>
Timestamp myTs = new Timestamp(System.currentTimeMillis());

PreparedStatement myStatement = con.prepareStatement("insert into
mytable (myID, myTimestamp) values (?,?));
myStatement.setString(1, "4451234578521");
myStatement.setTimestamp(2, myTs);
myStatement.execute();

Data that get inserted is:

4451234578521  2004-07-11 15:34:26.234

When I create a timestamp using the system.currentTimeMillis it just
doesn't create a timestamp that has the precision I want.  I want the
timestamp out past the millisecond and out to the microsecond like
2004-07-11 15:34:26.274123.  How would I use the timestamp object to get
to that precision?  Do I have to use a JNI call?

- Greg Markham