Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> from max date - 7 days

from max date - 7 days

From: sansar <uemit.uenlue_at_googlemail.com>
Date: Fri, 19 Oct 2007 02:39:20 -0700
Message-ID: <1192786760.399729.64990@z24g2000prh.googlegroups.com>


hallo !
can me somebody say, how i get from this select statement max date - 7 days.

select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyyy')) from dba_tab_partitions
where table_name='FRONTEND_TAB'

thank you

Oracle info: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production Received on Fri Oct 19 2007 - 04:39:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US