•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,493 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,776 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 1355 | Replies: 4
 |
•
•
Join Date: Feb 2008
Posts: 36
Reputation: 
Rep Power: 1
Solved Threads: 1
Light Poster
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
ex: 25-FEB-2008 and 05-MAR-2008
in this i want get 5 days only not 10 days
•
•
Join Date: Sep 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 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???
Do you want to get the difference between the day you give as input and the end of month or start of month???
•
•
Join Date: Feb 2008
Posts: 36
Reputation:
Rep Power: 1
Solved Threads: 1
Light Poster
•
•
•
•
Originally Posted by 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???
if i give days between 4 months, but i want days only till end of the first month only
•
•
Join Date: Sep 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 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
You have a function called last_day in oracle.
< select (last_day(trunc(sysdate))-trunc (sysdate)) DayDiff from dual >
Resulted in
DayDiff
--------
4
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,270
Reputation:
Rep Power: 4
Solved Threads: 80
•
•
•
•
Originally Posted by brr
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.
Share your Knowledge.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- how to make member expire after so many days with php script (PHP)
- cable got slower over a couple of days (Networking Hardware Configuration)
- Logic to Convert Days From 1800 to a Date (Month, Day, Year) (C++)
- daniweb down for two or three days. (Geeks' Lounge)
Other Threads in the Oracle Forum
- Previous Thread: Table drop and Dependent Objects
- Next Thread: plsql mathematical function
