Ask Question
Help Others
Home › PeopleSoft › PeopleCode › Built-in Functions

Changing Date Format Using PeopleCode

Tue, 08/05/2008 - 5:29am — aryadav
No votes yet

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.

Bookmark/Search this post with:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Fri, 08/29/2008 - 3:09pm
#1
Lepa's picture
Lepa
User offline. Last seen 1 day 8 hours ago. Offline
Joined: 06/23/2008
Posts: 412
Re: Changing Date and Date time formate example

Here is an example on how we can apply the above function.

%date in as 2008-08-29 out as 20080829:

&date = DateTimeToLocalizedString(%Date, "yyyyMMdd");

%Datetime in as 2008-08-19-17.12.09.000000 out as 20080828-171209:

&datetime = DateTimeToLocalizedString(%Datetime, "yyyyMMdd-HHmmss");

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

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.

CAPTCHA
The question below is to prevent automated spam submissions.
1 + 6 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.