#13793: Aqua-script : Selected datetime Result Format not reflected on result set in browser.

nileshhmali reported 2015-10-23T13:16:08Z · last modified 2018-03-15T20:32:53Z

Dev	tariqrahiman
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Open API - Aqua
Version	Future

Product: Aqua Data Studio

Version: 17.0.0-rc-22

Build #: 46570

Build Date: 2015-Oct-22 03:35:55 PM

Operating Environment: Linux (3.19.0-15-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b26

Memory: Max=704,643,072; Total=696,778,752; Free=381,421,792; CPUs=8

Connect Ms-Sql server-2014

Step-01:

Go to File->options->Result Format

Select Ms-Sql server-2014 Database

Select Timestamp datatype from drop down

Select Format "yyyy.MM.dd G 'at' HH:mm:ss z"

Click on Ok button

Step-02

Execute select script(table contain datetime value) on query analyzer window.

Right click on result set and select Generate Aqua-script option

Aqua-script generated successfully.

Click on debug in browser icon.

Result set displayed in browser.

You can see that,Selected date-time Result Format is not reflected on result set in browser.

Is it expected behavior?

All Comments (2) Change History

SachinPrakash 2015-12-01T03:26:04Z

@nilesh: can you provide the aquascript code that will generate the desired format.

nileshhmali 2015-12-01T04:18:21Z

Please refer datetimeformat.xjs.