Retrieve database timestamp data with miliseconds precision

[jpnavarini]

I'm using the LabView 8.5, and I have to access a Oracle database to gather, among other things, a TIMESTAMP type of data with miliseconds precision.

I succeeded to retrieve the TIMESTAMP Oracle field using the "Oracle Provider for OLE DB" driver, but the data precision ends at the seconds field, even if the database is filled with information with miliseconds precision.

I also noticed that LabView is showing the retrieved TIMESTAMP data with the same format as it's defined at the Windows Regional Settings.

How can I retrieve data from an Oracle database with miliseconds precision?

[K C]

Can you show the raw data that you get from the Oracle DB ?

[jpnavarini]

Data in Oracle DB: "6/1/2009 14:12:10.890"

Data retrieved in LabView Variant array, using Oracle OLE driver: Value->"6/1/2009 14:12:11"

Notice that LabView rounded the seconds. 10.890 s became 11 s.

Any clue on it?

Thanks in advance,

jpnavarini