Skip to Main Content
Forums

SQL & PL/SQL

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 of (fisrt day and last day) last month

770542Jun 27 2012 — edited Jun 28 2012
hi,

i need to calculate first day of last month accounding to the sysdate, like below

('01.05.2012 00:00')

i need to calculate last day of last month accounding to the sysdate, like below

('31.05.2012 23:59')

thank you
This post has been answered by 21205 on Jun 27 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2012
Added on Jun 27 2012
11 comments
50,190 views