Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Format in PeopleSoft Query Expressions

844223Mar 2 2011 — edited Mar 7 2011
Hello,
I have devloped a query where one of the field has date field. The format that's showing is 'MM/DD/YYYY'. We want the format in 'MM-DD-YYYY'. I tried to create a expression using to_char(A.fieldname,'MM-DD-YYYY'). But its not working. Is there any other way we can get the format in 'MM/DD/YYYY' from query manager.

Thanks,
-Sam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2011
Added on Mar 2 2011
#peoplesoft-general-discussion
5 comments
10,537 views