Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: from max date - 7 days
On Oct 20, 5:40 am, sansar <uemit.uen..._at_googlemail.com> wrote:
> On 20 Okt., 10:17, William Robertson <williamr2..._at_googlemail.com>
> wrote:
>
>
>
>
>
> > On Oct 19, 12:10 pm, sansar <uemit.uen..._at_googlemail.com> wrote:
>
> > > On 19 Okt., 11:39, sansar <uemit.uen..._at_googlemail.com> wrote:
>
> > > > 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
>
> > > select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyyy')) - 7 from
> > > dba_tab_partitions
>
> > > where table_name='FRONTEND_TAB';
>
> > Can you give an example of some partition names? I'm surprised they
> > have dots in them.
>
> > Can you be sure the names will always match the expected format? Looks
> > a rather fragile approach to me.
>
> the partition name is:
> for example= "part_19.10.2007"
> when i give "" to the partitio names, that makes don't problems
Could it be that putting the dot in makes it look for a schema named part_19? And putting the quotes on protects the partition name from schema translation? Or something like that.
jg
-- @home.com is bogus. Ad on dizwell blog post about shutting down: http://h71028.www7.hp.com/enterprise/cache/523434-0-0-0-121.html?jumpid=ex_hphqglobal_disasterproof/disasterproof/googleReceived on Mon Oct 22 2007 - 15:32:56 CDT