Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DB - Excel |
| Version | 15.0 |
Our Excel JDBC Driver uses the Aspose API. For datetime, date, and time values, the Aspose API always returns those values as com.aspose.cells.DateTime. Even if the value has only a time value, a dummy date value is attached to the time value. If you run a SELECT query, you will see both the date and time values.
Unfortunately, due to this limitation of the Aspose API, ADS treats all datetime, date, and time values as "timestamp" values. I made the following code changes for Excel connections:
- In the Options tab of the Export dialog, the "Date" and "Time" formatting options are disabled.
- Renamed the "DATE" data type to "TIMESTAMP" when generating the CREATE TABLE statement.
Verified in Aqua Data Studio 15.0.0-dev-66
Verified in Aqua Data Studio 15.0.0-dev-66
Verified in Aqua Data Studio 15.0.0-dev-86
Verified in Aqua Data Studio 15.0.0-dev-86
Issue #11158 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 15.0.0-dev-64 |
| No time estimate |
Our Excel JDBC Driver uses the Aspose API. For datetime, date, and time values, the Aspose API always returns those values as com.aspose.cells.DateTime. Even if the value has only a time value, a dummy date value is attached to the time value. If you run a SELECT query, you will see both the date and time values.
Unfortunately, due to this limitation of the Aspose API, ADS treats all datetime, date, and time values as "timestamp" values. I made the following code changes for Excel connections:
- In the Options tab of the Export dialog, the "Date" and "Time" formatting options are disabled.
- Renamed the "DATE" data type to "TIMESTAMP" when generating the CREATE TABLE statement.