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):
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...
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