I have updated my ignition from7.9.1 to 7.9.21 but I got an error in my query
would you please help me
You probably need to stop using string conversions of your datetime values. Now that you've upgraded, you have named queries available, which can pass datetime values in DB native binary format. You should do so. (And get rid of all of the other string substitutions--they are not secure.)
1 Like
Thank you so much for the help, but right now I need to make it work and then I will change to the named query
this is an old design for another company, and I don't know how many things I need to change
I just now need help to keep going
I changed TO_DATE to TO_TIMESTAMP too but still the same error
You are string converting datetimes from java, and they appear to be including milliseconds. You are handing that string to Oracle to parse back into a timestamp, but your pattern doesn't have milliseconds. Fix the parsing pattern.
Or convert your datetimes to strings in separate custom properties that ensure you get a db-compatible date format. (You might be able to eliminate the explicity to_date() in your SQL.)
1 Like