Apparently PocketQuery interprets the colon in the date format descriptor as a parameter designator:
TO_CHAR(SAMPLE_TIME,'Mon dd, HH24:00') as SAMPLE_DTTM
Is there a way how would I escape the colon to use it as a literal?
I tried to reproduce the problem with a sample MySQL database (this shouldn't be Oracle-specific) but I couldn't. I used this statement:
SELECT Name, DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p') AS MyDate FROM Country;
Can you provide your full statement?
Thank you for responding to this.
Here it is
select TO_CHAR(SAMPLE_TIME,'Mon dd HH24:mm') as SAMPLE_DTTM, NVL((1-m.AVG_IDLE_TIME) , 0) as "Hourly Load Average" from JON_DASH.JON_HOST_METRICS M where HOSTNAME=:hostname and SAMPLE_TIME> SYSDATE-28 order by SAMPLE_TIME asc
And that's how it is presented with the macro config (the 'mm' parameter, which it should not be):
Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG