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: 26766
Registered: January 2009
Location: SoCal
Senior Member
WHERE SOME_DATE > TRUNC(MAX(SOME_DATE)-30)

Report message to a moderator

Previous Topic: dbms_scheduler
Next Topic: PL/SQL error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 04:31:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.