HELP:From todays date, determine previous month end calendar date [message #299219] |
Sun, 10 February 2008 20:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
icm63
Messages: 22 Registered: December 2007
|
Junior Member |
|
|
Are they any functions that can dp this ....
From todays date, determine previous month end calendar date
So todays date is 2/11/2008, result would be 1/31/2008
Any ideas how to make this a functions. I am a newbie to functions. I know I can do this in a table and join, but seams a waste of space.
Please help
|
|
|
|
|
|
Re: HELP:From todays date, determine previous month end calendar date [message #299261 is a reply to message #299252] |
Mon, 11 February 2008 01:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Shakti,
You should read OraFAQ Forum Guide and especially "Responding to Posts" section:
Quote: | When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, especially in the homework and newbies forums, it is usually best to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, rather than providing complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.
|
You should also read "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Indent the code. Use the "Preview Message" button to verify.
Regards
Michel
[Updated on: Mon, 11 February 2008 01:18] Report message to a moderator
|
|
|
|
|