Datetime results are not same with exported xlsx format of a query result

Details

  • Fix Build Number:
    8.4.1.2109

Description

1. Run a query on err01.png
2. Export data by exporting function on query editor results (format is xlsx)
3. xlsx result are not same on original db.

  1. File
    20120428_com.cubrid.common.ui.creview
    27/Apr/12 10:32 PM
    6 kB
    Isaiah Choe
  2. Microsoft Excel
    aaa.xlsx
    19/Apr/12 1:01 AM
    3 kB
    Isaiah Choe
  3. File
    com.cubrid.common.ui.creview
    19/Apr/12 1:25 AM
    6 kB
    Isaiah Choe
  1. err01.png
    12 kB
    19/Apr/12 1:01 AM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Isaiah Choe added a comment -

It is a problem of xlsx.
I think, xls/xslx seems to be not supported milisecond on datetime type.
We will fix this issue that the datetime type treat as text type.
Currently, it is similar with the function of xls exporting.

Show
Isaiah Choe added a comment - It is a problem of xlsx. I think, xls/xslx seems to be not supported milisecond on datetime type. We will fix this issue that the datetime type treat as text type. Currently, it is similar with the function of xls exporting.
Hide
Permalink
Isaiah Choe added a comment -

It is related on com.cubrid.common.ui.query.control.Export class.

Show
Isaiah Choe added a comment - It is related on com.cubrid.common.ui.query.control.Export class.
Hide
Permalink
Isaiah Choe added a comment -

Fixed. But, after you edit a cell with the datetime type, it is not a text type anymore. That is, it may be turned one of date relation types.

Show
Isaiah Choe added a comment - Fixed. But, after you edit a cell with the datetime type, it is not a text type anymore. That is, it may be turned one of date relation types.
Hide
Permalink
高艳铭 added a comment -

Regression result in CM8.4.1.2100

Datatime is ok. but the date, timestamp display the format like yyyy-mmm-dd

Shall we change it to yyyy-mm-dd?

Show
高艳铭 added a comment - Regression result in CM8.4.1.2100 Datatime is ok. but the date, timestamp display the format like yyyy-mmm-dd Shall we change it to yyyy-mm-dd?
Hide
Permalink
Isaiah Choe added a comment -

Fixed date, datetime, timestamp, time.

Show
Isaiah Choe added a comment - Fixed date, datetime, timestamp, time.
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2109 and CQB8.4.1.2109

Show
高艳铭 added a comment - Fixed in CM8.4.1.2109 and CQB8.4.1.2109

People

  • Assignee:
    高艳铭
    Reporter:
    Isaiah Choe
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
0m
Original Estimate - 0 minutes
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
1h
Time Spent - 1 hour