CODEWITHSUNDEEP
sqloracle-databasedate
josejex
josejex

Reputation: 13

How can I take the seven days before a date in Oracle SQL?

How can I take the seven days before a date in Oracle SQL?

The query is

SELECT
  *
FROM log
WHERE action = 'KA'
AND REPOMOD

REPOMOD is a field Date

Upvotes: 0

Views: 3081

Answers (1)

Damini Suthar
Damini Suthar

Reputation: 1492

select * from log where action = 'KA' 
And REPOMOD >= sysdate -7

Upvotes: 2

Related Questions