i have to get days of that particular month , that is if i give dates between different months like
ex: 25-FEB-2008 and 05-MAR-2008
in this i want get 5 days only not 10 days

Hi,
Do you want to get the difference between the day you give as input and the end of month or start of month???

Hi,
Do you want to get the difference between the day you give as input and the end of month or start of month???

if i give days between 4 months, but i want days only till end of the first month only

Hi,
You have a function called last_day in oracle.
< select (last_day(trunc(sysdate))-trunc (sysdate)) DayDiff from dual >

Resulted in
DayDiff
--------
4

if i give days between 4 months, but i want days only till end of the first month only

why you need to pass dates for that.

Last_day will do that for you with only one parameter.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.