how to make NOW() tomorrow
[136 byte] By [elfadotontoa] at [2007-10-2 15:56:20] 
I have a DATE(NOW()) in my sql statement.are there any clever ways to get tomorrow instead of today?like now()+1...
Yes but this database dependent. You could do this in Java just as easily using a Calendar object and it would not be as database implementation specific.
elfadotontoa at 2007-7-13 16:15:36 >
> I have a DATE(NOW()) in my sql statement.> > are there any clever ways to get tomorrow instead of today?Sure, wait a day.%
duffymoa at 2007-7-13 16:15:36 >
Database Connectivity New Topic
Database Connectivity Hot Topic
- Shared RowSets not in sync after Insert or Delete
- java + relation database and java + Xml wich one is more better
- Connection Pooling / Context Problem
- SQL and Microsift Access database problems
- JDBC Connection Driver Problem for Oracle in a J2EE servlet/class
- CMT Transaction Question
- Lock records
- Initial Select Slow
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