I would like to ask for help:
I’m working in a project using only named querys and I added a function to get only the hour of a date
for example: substr(date_field,11) between ('07:00:00) and (‘15:00:00’).
The query runs without problems in sql developer and returns the correct number, but when I change the query to Ignition to get the same value in a label, I only get a 0, and Ignition doesn’t not inform about any error.
I use 8.1.0 Ignition version.
I hope you can help me with this doubt I have and can solve my issue.
Thanks in Advance
Could you post the exact query that you're running in Ignition or SQL Developer? Are you getting the same result if you run that query in the Database Query Browser of the Designer?
but when I change the query to Ignition to get the same value in a label
How is this value from the query coming to the label? (Named Query binding, scripting, etc)
On a side-note, I highly recommend upgrading to the latest version of Ignition 8.1 if that is an option for you to receive any bug fixes that have released since that time especially if you are still in the development stage.