PeopleSoft Query surrounds dates and datetimes from the database with a conversion to consistent format. This is similar to the effect of
the PeopleCode %DateOut, %TimeOut and %DateTimeOut. The effect of this can be seen when you preview the SQL.
The date functions are particular to the database in use. For instance in Oracle:
The conversion to char means that the date functions will not work natively. You can convert this back to date by creating an
expression as follows:
This means that you can then use date functions:
Note that DateTimes can be converted differently and so care is needed when mixing data types.