dateadd in plsql? [message #435979] |
Sun, 20 December 2009 08:50  |
pyscho
Messages: 134 Registered: December 2009
|
Senior Member |
|
|
I'm in the processw of converting TSQL to PLSQL and come across a slight problem.
DATEADD(MONTH, @months * -1, GETDATE())
Is there a way to do the same thing in plsql, so that I can go back a certain number of months.
|
|
|
|
|
|
|
|
|
|
Re: dateadd in plsql? [message #436055 is a reply to message #436049] |
Mon, 21 December 2009 04:06   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 21 December 2009 10:50Quote:But as I didn't see any point to point answer or link
But doesn't the following clear:
Quote:in the link I posted in your previous topic.
Doesn't it? Doesn't it? Doesn't it?
Regards
Michel
How would this help other people? You cannot expect them to search for other posts by the same poster.
|
|
|
|
Re: dateadd in plsql? [message #436061 is a reply to message #436055] |
Mon, 21 December 2009 04:50   |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote:How would this help other people? You cannot expect them to search for other posts by the same poster.
I agree so we must give a full answer to lazy guy just to help the other ones?
Regards
Michel
[Updated on: Mon, 21 December 2009 04:52] Report message to a moderator
|
|
|
Re: dateadd in plsql? [message #436179 is a reply to message #436061] |
Tue, 22 December 2009 00:53   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 21 December 2009 11:50Quote:How would this help other people? You cannot expect them to search for other posts by the same poster.
I agree so we must give a full answer to lazy guy just to help the other ones?
Regards
Michel
You don't HAVE to answer. If you feel a person does not deserve a full answer, move on to the next topic. Don't bash others for giving them answers though. Remember that this is a community. Its existence depends on multiple people being involved.
|
|
|
|
|
|
|
Re: dateadd in plsql? [message #436362 is a reply to message #436340] |
Wed, 23 December 2009 01:25  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
You're currently acting like a troll.
The discussion was ended, you have no need to awake it with stupid comment.
Regards
Michel
|
|
|