| Subject | By | Forum | Posted on |
|---|---|---|---|
| Integration Broker Help needed | nitin_hexa | 08/01/08 | |
| Paragraph Right Alignment in SQR | venkat.srinivas18 | 07/31/08 | |
| epm | Guest | 06/16/08 | |
| Transfer Assets | Guest | 05/09/08 |
Do you find yourself with few minutes to spare, and a desire to help other CompShackers?
Submit a tip, code or an SQL snippet. Start an article about topics you are familier with, or edit a Wiki page. Help the community grow larger by sharing a little bit of what you know!
Reasons why this is great:
Note: Registration required. Guests can edit Wiki pages.
Few posts back, I wrote about how to call a UNIX script from PeopleCode. In this post, I will provide a sample code to call a UNIX script from an SQR program.
Many times we came across situation where we have Page name but we dont know the navigation for this page in Portal.
Following SQL makes the job easy for us.
Execute the following SQL in Database.
Peoplesoft provides a function called as "DateTimeToLocalizedString" to change date from one format into another.
Following is syntax used to achiev this.
DateTimeToLocalizedString (Param1,Param2);
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.