Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Excel
Column Type Question
BM Kim
2007-09-06 22:15:45.0
Hi, I'm software engineer in south korea.
I have a question about HXTT Excel.
I make one table in my excel file.
it has several columns and one is DATE type.
I just querying "SELECT * FROM TABLE".. and I find
the column typed DATE is treated VARCHAR with
resultSetMetaData.getColumnTypeName(i).

How can I teach column type to HXTT Excel?
or How can I get it with Date Format?

Data in table tyoed DATE is like this : 2007-08-24 7:00:00 AM
Re:Column Type Question
HXTT Support
2007-09-06 22:46:49.0
>the column typed DATE is treated VARCHAR with
>Data in table tyoed DATE is like this : 2007-08-24 7:00:00 AM
It means that it's stored as text format, not date format, in Excel. You can try CDATE and CTOT at here. For instance, select cdate(column2) from atble;
Re:Re:Column Type Question
BM Kim
2007-09-06 23:47:02.0
Thank you so much for your QUICK response.

sorry for my mistake about TYPE of column.
HXTT Excel treats DATE column as DOUBLE.
Actually, my excel seems to denote the column type - DATE.
In my excel, excel shows that with 2007-08-25 7:00:00 AM, but
HXTT Excel shows 39316.291666666664 for that.

so, with CDATE function, I get the error like this :
java.sql.SQLException: Correct date format: 'yyyy-mm-dd', 'hh:mm:ss' and `yyyy-mm-dd hh:mm:ss.f...', but you have used '39316.291666666664'!

please let me know how can i get the DATE data.

Thanks in advance.
Re:Re:Re:Column Type Question
HXTT Support
2007-09-07 01:41:01.0
>In my excel, excel shows that with 2007-08-25 7:00:00 AM,
> but HXTT Excel shows 39316.291666666664 for that.
It's possible since MS Excel stores date and double in the same format. You can send webmaster@hxtt.com such a nxls sample, then we will dig out it.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap