Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Write a query to subtract days from todays date

Posted By: Adalricus Fischer     Category: Oracle     Views: 29422

Write a query to subtract days from todays date.

Write a query to subtract days from todays date.

SELECT SYSDATE-10 FROM dual;

Output : 

SYSDATE-1
16-APR-97

This command will subtract 10 days from the current date.
  
Share: 


Didn't find what you were looking for? Find more on Write a query to subtract days from todays date Or get search suggestion and latest updates.

Adalricus Fischer
Adalricus Fischer author of Write a query to subtract days from todays date is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
Akshay Kadu from India Comment on: Dec 25
select substr(sysdate,1,2) from dual;

View All Comments