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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Transformation in Oracle

Status
Not open for further replies.
shimin

shimin

Technical User
Mar 11, 2004
4
US
Anyone know how to transform current month date into prior month date using a SQL statement that will be embedded in a transformation?

thanks for the help.
 
Sort by date Sort by votes
here is the answer apparently:

select dt_id,
add_months (dt_id,-1)
from miw.t_tm_dim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

darklord2
  • Locked
  • Question
Count when the dates match
Replies
0
Views
259
darklord2
darklord2
dinzana
  • Locked
  • Question
Comparing sysdate()-1 to another date in multiple datasets in a report document.
Replies
0
Views
240
dinzana
dinzana
szeiss
  • Locked
  • Question
Display FY2011 instead of FY-1 in Report
Replies
0
Views
204
szeiss
szeiss
156s
  • Locked
  • Question
Date prompt in freeform
Replies
0
Views
200
156s
156s
Lironcareto
  • Locked
  • Question
Pick max date from a table
Replies
0
Views
352
Lironcareto
Lironcareto

Part and Inventory Search

Sponsor

Back
Top