I have two dates that are oracle DATE type. How to subtract and get days/hr
[252 byte] By [adamrau] at [2007-9-26 2:30:35] 
How to subtract two oracle dates and get the result in days/hours/minutes/seconds.Oracle keeps telling me that i need to do PL/SQL but i dont know it. They will not give me an example in JAVA so i came here.ThanksAdam
Does anyone have any idea on how to accomplish this. Is there anyway to convert the dates to java dates and then do the calculation.THanks again
adamrau at 2007-6-29 9:49:38 >
As long as you know what format they are in you can use java.util.simpleDateFormat to parse them as a java date. Take a look at the class documentation to see how.
Breakfast at 2007-6-29 9:49:38 >
You mean java.text.SimpleDateFormat :o).
rajbhaskar at 2007-6-29 9:49:38 >
I don't like to make things too easy for people ;-)
Breakfast at 2007-6-29 9:49:38 >
Enterprise & Remote Computing New Topic
Enterprise & Remote Computing Hot Topic
Enterprise & Remote Computing
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding