× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2015-01-15T18:00:16Z  · tomconrad last modified 2018-03-13T18:20:27Z

use database specific formatting for Paste to Window > INSERT Body dates/timestamp (like we do for Export)


customer request PM
Dev
Kin-Hong Wong
kin-hong
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Q Analyzer - Grid Results
Version Future

When copying a date from the Grid Results of Oracle, and a timestamp is encountered, we should be pasting using Oracle syntax if Paste to Window > INSERT Body is used to get this content in the Query Analyzer. Currently we are using a generic formatting for date/timestamp not tied to a DB type.

'2013-03-19 16:07:32.227',

vs the more DB specific

TO_DATE( '2013-03-19 16:07:32', 'YYYY-MM-DD HH24:MI:SS')

 

Our Export tool uses DB specific formatting, so we should be using that from the Grid Results > (right click selection) > Paste to Window > INSERT Body

Issue #13043

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