| 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 ]
|
|
 |
|
|
subject: SQL date
|
|
|
0
