This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL date" Watch "SQL date" New topic

SQL date

Mike Yu
Ranch Hand

Joined: Nov 17, 2001
Posts: 175
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

Joined: Jan 29, 2002
Posts: 27
select sysdate-100 from dual;
select current_date-100 from dual;
This works in oracle.
[ October 30, 2002: Message edited by: Les Dsouza ]
I agree. Here's the link:
subject: SQL date
Similar Threads
getting current date -applets
Why they have named a calendar method like this?
current system date using sql date
get column value in a database
how to get yesterdays date using jsp