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
|
>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;
|
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.
|
>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.
|
Main
webmaster@hxtt.com