× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
samjacinto reported 2017-11-21T15:02:11Z  · tomconrad last modified 2018-03-08T21:17:41Z

Expand the timestamp/time field in the table data editor to hold microseconds


customer request PM
Priority Minor
Complexity Unknown
Component DB - DB2 zOS
Version Future

Case# 00603610

Customer: LVM Versicherung 

User: Rainer Schmedt auf der Günne 

I have changed the overall timestamp appearance as you suggested. This could be a good workaround for some of the data in timestamp format. 

But, timestamps in DB2 on z/OS use a six-digit-number in the microseconds. After changing the overall timestamp format to the German format JJJJ-MM-TT-HH.mm.ss.i (seems to be equal to yyyy-MM-dd-HH.mm.ss.S as American format) the table editor of aqua data studio now uses a better format, but not the right one, because 3 digits of the microseconds are missing. This is a problem, especially in tables with a timestamp primary key.

2 attachments

Issue #15491

New
 
 
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