Skip to Main Content

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 Functions( first day of a month that is 3 months from now....)

487726Feb 17 2006 — edited Feb 17 2006
I have recently written my first stored procedure.
Its rather a bunch of SQL statements.

I had to hard code lot of dates. most of them are first day of the current monthe or last day of current month etc.

I thot of parametrizing all the dates, but if a business person has to include all the parameters they could go wrong and get the wrong results.

Now, I want to use date functions to achieve these requirements:
Can any one please throw some insght into this:....

1) First day of current month,
2) last day of current month.
3) first day of previious month
4) last day of previous month
5) first day of a month that is 3 months from now.
6) last day of a month that is 3 months from now.
7).....

Can any one please throw some light on any one of this.. I can try to work from there onwards ....

Thanks a lot in advance,
Ac
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2006
Added on Feb 17 2006
5 comments
2,000 views