Dates in PS Query
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.
More About Functions
|For more information about functions in PeopleSoft Query and some other interesting stuff too, read our eBook:|