You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How to obtain the number of days of a month in PeopleSoft Query

1 reply [Last post]
Guest's picture
Guest

Hello,
In PeopleSoft Query how can I obtain the days of a month in a certain date using an expression?
for example 10/08/2013, what is the number of days for month 08 (August).

Thanks,
Angelica

Ashar's picture
User offline. Last seen 4 years 34 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: How to obtain the number of days of a month in ...

If you are on Oracle, You can use TO_CHAR(LAST_DAY(date_column),'dd')

/Ashar