Product: Aqua Data Studio
Version: 17.0.0-rc-44
Build #: 47271
Build Date: 2015-Nov-26 08:30:57 AM
Operating Environment: Linux (3.13.0-62-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=483,917,824; Free=258,119,272; CPUs=8
Steps to reproduce the issue :
1) Connect to Sybase Anywhere 16 Database.
2) Create a Table with time data type in any schema.
CREATE TABLE nishtha.test_time (
c1 time NULL
)
GO
3) INSERT some values in this table.
INSERT INTO nishtha.test_time(c1)
VALUES('18:15:30')
GO
4) Run Select * query to check data.
SELECT * FROM nishtha.test_time
GO
5) Now Export data of this table into test_time.csv file.
Data in "test_time.csv" file :
c1 |
06:15:30 PM |
5) Also Export data of this table into test_time.xls file.
Data in "test_time.xls" file is :
c1 |
'0001-01-01 18:15:30.0 |
Data is exported as String.
7) Now Import data from "test_time.csv" file into table 'test_time'.
Data imported successfully.
8) Now Import data from "test_time.xls" file into table 'test_time'.
Below error message is displayed.
test_time --> Warning: Row: 1 -- Column:c1 type:time :Unparseable date: "0001-01-01 18:15:30.0" --
Time value is exported as String And when we import this value in to table 'test_time', error message is displayed and Null is inserted into table.
Is this acceptable?
Please refer attached screenshot "SybaseAnywhere_time_datatype.png".
Also refer attached "test_time.csv" and "test_time.xls" files.
Observation : In PostgreSQL and Sybase ASE databases if we export value of time datatype into excel file, data displayed in excel file is :
Value is exported as Date into excel file.
c1 |
1970/01/01 18:22:22 |
And when we Import this value into table, data imported successfully.
|
153 KB
![]() |
19 B
![]() |
4 KB
Same issue is Observed for SybaseIQ Database.
Same issue is Observed for 'bigtime' datatype in SybaseASE.
Issue #13899 |
Closed |
Completion |
No due date |
No fixed build |
No time estimate |
Same issue is Observed for SybaseIQ Database.
Same issue is Observed for 'bigtime' datatype in SybaseASE.