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
brr
0
Light Poster
Recommended Answers
Jump to Postif 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.
All 4 Replies
RamyaJayaram
0
Newbie Poster
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
0
Light Poster
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
0
Newbie Poster
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
580
Posting Genius
Featured Poster
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.