want to get time upto nanoseconds

[selani]

Hi all,

i want to get time upto nanoseconds.I tried using Timestamp class but did not serve the purpose.It saves the milli second value as nanos portion.That is wat i understood.
Can anyone help me?

thanx in advance
selani

 

[maxpower1]

you have to explicitly request the nano value to be passed back to your function. hence, make sure to use getNanos()
method.

http://stein.cshl.org/jade/distrib/docs/java.sql.Timestamp.html

~za~
You can't bring back a dead thread!

 

[selani]

Hi,

Thanx.i hv already tried wat u hv mentioned.
When i print the Timestamp obj i get the following output:
2003-08-08 10:08:54.478

getNanos returns the foll:
478000000

i.e. it is returning the milli sec part of time.Isn't it?
wat i want is nano seconds.i don't understand this.

Can u clarify?

 

[hologram]

According to the API doc :

"A thin wrapper around java.util.Date that allows the JDBC API to identify this as an SQL TIMESTAMP value. It adds the ability to hold the SQL TIMESTAMP nanos value and provides formatting and parsing operations to support the JDBC escape syntax for timestamp values." ,

it is my understanding that TimeStamp is a container to store the nanaseconds, but somebody has to put that value in e.g. the nanoseconds could be put in there via JDBC. Not via Date or Time or System.currentTimeMillis(), because they all do not contain nanoseconds.

 

[jwenting]

It could well be that your JDBC driver (and/or your database) don't support greater precision.

Even if the data entered into the database has the desired precision, if the JDBC driver can't handle it it will not return it.