Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DATES

Status
Not open for further replies.
Olivia123

Olivia123

MIS
Apr 19, 2007
29
US
Hello,
How can I in this sql script subtract 7 days from the DATE_CREATED.

SELECT * FROM F_ACCOUNTS

WHERE TRUNC(date_created) = (SELECT TRUNC(MAX (date_created)) FROM F_ACCOUNTS)

Thank you

 
Sort by date Sort by votes
You can use arithmetic on dates. For example to subtract seven days do

date_created - 7

To go back 1 day and 5 hours do

date_created - (1 + (5/24))



Bill
Oracle DBA/Developer
New York State, USA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LarrySteele
  • Locked
  • Question
SQLLDR adding a century to pre-1950 dates
Replies
7
Views
359
Beilstwh
Beilstwh
Sahubba
  • Locked
  • Question
Dates and Time
Replies
5
Views
74
Beilstwh
Beilstwh
ddrillich
  • Locked
  • Question
Formatting of dates subtraction 1
Replies
7
Views
65
carp
carp
ronaldmacdonald
  • Locked
  • Question
sql query - working days between two dates (including public holidays)
Replies
9
Views
303
ronaldmacdonald
ronaldmacdonald
jasonhuibers
  • Locked
  • Question
Need to retrieve Max 3 dates
Replies
3
Views
59
Turkbear
Turkbear

Part and Inventory Search

Sponsor

Back
Top