How to get that day before seren days of today!
[233 byte] By [yukinglie] at [2007-9-26 1:44:56] 
My English is poor! I have a problem!How to get that day before seren days of today,and coveren(change) to string varilble. quest that because I need make this SQL.select * from table1 where theday=today-7
«« J2EE Server 1.2.1 Security Manager (Altering File Permission)
»» Please Help !!! XML beginner using Xerces
»» Please Help !!! XML beginner using Xerces
Can you help!
yukinglie at 2007-6-29 2:40:52 >
SQL != JavaKirk
kswoll at 2007-6-29 2:40:52 >
in oracle this should work:
select * from table1 where trunc(theday)=trunc(sysdate-7 )
but I believe its database dependent.
sysdate is the current date + time
trunc if applied to a date sets the time to 0:00:00
HTH
Spieler
PS: Do not crosspost ... sql question if you have to post
them on jdc belong in the jdbc forum
spieler at 2007-6-29 2:40:52 >
Archived Forums New Topic
- Error java.io.FileNotFoundException
- Error FileReader / FileWriter use different charSet
- What exactly is InheritableThreadLocal Storage, and how exactly do I use it
- JPanels containing mutable JLabels in a JTree?
- my brain hurts! need help with ArrayList in Java!
- CRC32 vs checksum
- Modal Dialog question
- anybody out there, please help with this conversion..
Archived Forums Hot Topic
Archived Forums
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