JavaDb Date Calculation
[151 byte] By [DStaelens1a] at [2007-11-27 6:38:58] 
In Oracle, to find the date seven days ago, you can do a select sysdate -7 from dual, Is there an equivalent in JavaDb?Thanks,Dave
# 1
What is "JavaDb"?jschella at 2007-7-12 18:07:54 >
# 2
It's the Sun supported version of Derby.I found the answer anyway, there's a function called TIMESTAMPADD, or TIMESTAMPDIFF.DStaelens1a at 2007-7-12 18:07:54 >
Database Connectivity Hot Topic
- sql forum or help with sql query
- Does Hibernate supports multiple schemas connection ?
- Query regarding the Class.forname method
- problem with executeQuery statement
- Creating Stored Procedure in Java
- MYSQL connector
- ResultSet merge
- When we need to use connection.releaseSavepoint(sp); ?
- Sorting A Database Into Alphabetical Order?
- Problem with big table (Oracle DB)
- jdbc
- how to hide username/password in JDBC program.
Database Connectivity
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