× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
JennyNishimura reported 2012-10-29T21:28:01Z  · last modified 2012-11-06T17:16:06Z

Problem with MySQL Datetime value when viewing in spreadsheet


Dev mattbrumley(*)
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component Q Analyzer - Save Results
Version 12.0

- Go to File > Options > Results Format, choose [None] for MySQL DATETIME.  See attachment 1.
- In Query Analyzer, query some Datetime columns.  The values are displayed correctly in the Grid Results.
- Choose "View as Spreadsheet" or "Save Results" as an Excel spreadsheet, the values are displayed in an incorrect format in the spreadsheet.  See attachment 2.
 

If I choose [Default] for the result format, the values are displayed correctly in the spreadsheet.

2 attachments

Issue #7879

Closed
Fixed
Resolved 2012-11-03T16:50:08Z
 
 
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