Peoplesoft provides a function called as "DateTimeToLocalizedString" to change date from one format into another.
Following is syntax used to achiev this.
DateTimeToLocalizedString({datetime | date}, [Pattern])
Param1 : Variable of Date Datatype
Param2 : Date format which you want for example "dd/MM/yyyy".
If you have Param1 of type string then use function "DateValue" to convert that string to Date.
| Title | Under | Posted on |
|---|---|---|
| Embed External page into peoplesoft | PeopleSoft Technical | 06/30/2009 - 3:43am |
| Information required on Peoplesoft SCM tables | PeopleSoft Functional | 06/29/2009 - 6:02am |
| How do I return multiple rows when using START WITH in an Oracle stored procedure? | SQL & PL/SQL | 06/09/2009 - 3:44pm |
| Staging table issues | PeopleSoft Functional | 06/07/2009 - 6:59pm |
Comments
Here is an example on how we can apply the above function.
%date in as 2008-08-29 out as 20080829:
%Datetime in as 2008-08-19-17.12.09.000000 out as 20080828-171209:
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Post new comment