× Heads up!

Aqua Data Studio / nhilam

IDE for Relational Databases
JasonK reported 2015-04-02T20:25:02Z  · SachinPrakash last modified 2015-07-23T21:45:55Z

Can not convert data type in VA

customer request
Jenny Nishimura
Sachin Prakash
Priority Minor
Complexity Unknown
Component Visual Analytics
Version 16.0

Datase: H2

Table contains a Timestamp(10,10) column

Opening up a VA workbook from a query result set sets the data type for this column to a String (first issue).

Second issue, attempting to convert it from the String to a Date + Time by choosing Change Data Type -> Data and time doesn't seem to work (second issue). Viewing the data before the conversion it's something like "2015-03-02 12:13:34.0". After the conversion it then shows up as "null". Maybe it should complain about rows it wasn't able to convert so you at least know it failed (third issue)?

Changing the Date Format under "Default Properties -> Date Format to Custom with "yyyy-MM-dd HH:mm:ss'.0'" or "yyyy-MM-dd HH:mm:ss.0" neither seem to work-- both end up as null-- but I suspect this is for display of the date, not conversion, correct?

1 attachment

Issue #13207

Resolved 2015-04-02T22:26:55Z
No due date
Fixed Build 16.0.3-4
No time estimate

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