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):
It started as any story starts, on a normal, rainy day. Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs