Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.0.033
  HXTT Cobol 4.0.033
  HXTT DBF 7.0.033
  HXTT Excel 6.0.034
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox 7.0.033
  HXTT PDF 1.1.033
  HXTT Text(CSV) 7.0.033
  HXTT Word 1.0.031
  HXTT XML 3.0.033
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Excel
Times and Timestamps rounding down seconds.
Jim Hobday
2011-08-16 01:48:33.0
Dear HXTT,

Here is the third bug I've found today. I have sent the other 2 separately. There is no rush to fix these, so I am happy to wait till all three have been fixed. Of course if it is me that is not using the driver correctly then that would be even better.

I formatted some times and timestamps in the the Workbook LazyTest2.xls which I shall email to you. The columns are on the "Formatting" Sheet.

If you look at the first row of the Time column, the value is 12:23:00 but when I read the value using either getString() or getTime() i get 12:22:59

Similarly with the third row of the Timestamp column, the value is 13/11/2012 02:22:09 but when I read the value using getString() or getTimestamp() I get 2012-11-13 02:22:08.0

(I'm not bothered by the formatting - its the rounding of the seconds)

I guess it's the way that Excel stores times?

Cheers
Jim


Re:Times and Timestamps rounding down seconds.
HXTT Support
2011-08-16 03:10:44.0
Checked. It's resulted by MS Excel doesn't handle miliseconds. HXTT Excel will round miliseconds to seconds now too.
Re:Re:Times and Timestamps rounding down seconds.
Jim Hobday
2011-08-16 03:11:50.0
Great - thanks
Re:Re:Re:Times and Timestamps rounding down seconds.
Jim Hobday
2011-08-16 06:55:52.0
Thanks - that works perfectly as well.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap