Dates in PS Query
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Dates in PS Query
| Line 1: | Line 1: | ||
| - | 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. | + | [[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 date functions are particular to the database in use. For instance in Oracle: | ||
| - | to_char(A.EFFDT,'YYYY-MM-DD') | + | <pre>to_char(A.EFFDT,'YYYY-MM-DD')<\pre> |
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: | 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: | ||
