how to get days between

[brr]

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

[RamyaJayaram]

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

[brr]

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

[RamyaJayaram]

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

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

[debasisdas]

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.