Here’s a quick PS Query snippet : If you’ve ever wanted to use a colon in an expression – say something like displaying a colon between HH(hours) and MM(minutes), PeopleSoft PS Query would throw an error – because the Query parser thinks that the colon represents a bind variable.
Instead, you can create an expression that takes in the ASCII value of colon and use it in your PS Query.
So, your expression should be something like this:
HH | char(58) | MM
and the result would be
Here’s the ASCII table for reference : ASCII
Hope this helps! 🙂