A personal archive of PeopleSoft-related tips and tricks.
This is for SQL.
SELECT TO_CHAR(AUDIT_STAMP, 'yyyy-mm-dd hh24:mi:ss') FROM PSAUDIT;
And this is using PeopleCode.
DateTimeToLocalizedString(%Date, "yyyyMMdd");
No comments:
Post a Comment