*
The moose likes JDBC and the fly likes SQL date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL date" Watch "SQL date" New topic
Author

SQL date

Mike Yu
Ranch Hand

Joined: Nov 17, 2001
Posts: 175
Hi,
In SQL, using CURRENT DATE, we can get the current date, for example, '2002-10-29'.
How can we get a date that is 100 days earlier than current date? (using SQL only)


Thanks,<br />Mike
Les Dsouza
Greenhorn

Joined: Jan 29, 2002
Posts: 27
select sysdate-100 from dual;
or
select current_date-100 from dual;
This works in oracle.
regards.
[ October 30, 2002: Message edited by: Les Dsouza ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL date