× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nishtha(*) reported 2015-11-27T13:03:30Z  · tariqrahiman last modified 2016-10-25T20:21:26Z

SybaseAnywhere : Time vlaue is exported as String into excel file.


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Export Tool
Version Future

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.

 

3 attachments

Issue #13899

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017