Home » SQL & PL/SQL » SQL & PL/SQL » Max 30 date
icon5.gif  Max 30 date [message #252750] Thu, 19 July 2007 20:43 Go to next message
steve_kc
Messages: 5
Registered: July 2007
Location: Malaysia
Junior Member
Hi,

Anyone know Oracle got any function that retrun the MAX 30 date?

EG: Table A is store date from Jun 2007 till July 2007 date, I like to return 2-July-2007 till 31-July-2007 date.


Thanks in advance.

Regards,

Kian Chye

[Updated on: Thu, 19 July 2007 20:44]

Report message to a moderator

Re: Max 30 date [message #252753 is a reply to message #252750] Thu, 19 July 2007 21:06 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
WHERE SOME_DATE > TRUNC(MAX(SOME_DATE)-30)
Previous Topic: dbms_scheduler
Next Topic: PL/SQL error
Goto Forum:
  


Current Time: Thu Dec 08 04:09:59 CST 2016

Total time taken to generate the page: 0.08342 seconds