select add_months(sysdate,-2)
from dual
On Thu, Jun 18, 2009 at 12:49 PM, sakthi wrote:
>
> Hi ,
>
> SELECT ADD_MONTHS (SYSDATE, -1)
> FROM DUAL;
>
> where -1 is the number of months u want to remove from a date
>
> regards
> sakthi
>
> On Jun 18, 1:32 pm, Mouhammed Iyad wrote:
> > Nice day
Hi ,
SELECT ADD_MONTHS (SYSDATE, -1)
FROM DUAL;
where -1 is the number of months u want to remove from a date
regards
sakthi
On Jun 18, 1:32 pm, Mouhammed Iyad wrote:
> Nice day Dears,
>
> I know that there is a function for add_month()
> but is there a function or a way to remove a number
Many thanks
add_monthes(sysdate,-3) is working
but date-30 will not work
because I need to get the same day of the last month
Best Regards,
Iyad
On 18/06/2009, ddf wrote:
>
>
>
> On Jun 18, 4:16 am, sonty wrote:
>> You don't actually require a function to do so,
>>
>> try
>>
>> select your_da
On Jun 18, 4:16 am, sonty wrote:
> You don't actually require a function to do so,
>
> try
>
> select your_date-30*number_of_months_to_remove from your_table;
>
> or something similar.
>
> Regards,
> Sonty
>
> On Jun 18, 1:32 pm, Mouhammed Iyad wrote:
>
>
>
> > Nice day Dears,
>
> > I know tha
You don't actually require a function to do so,
try
select your_date-30*number_of_months_to_remove from your_table;
or something similar.
Regards,
Sonty
On Jun 18, 1:32 pm, Mouhammed Iyad wrote:
> Nice day Dears,
>
> I know that there is a function for add_month()
> but is there a function o
