Re: v$log_history and Y2K problem

From: Andrew Barnett <nobody_at_nospam.bp.com>
Date: 1998/03/04
Message-ID: <01bd470d$755fc700$4a0564a1_at_azmelw1358.mel.az.bp.com>#1/1


use RR format mask:

        to_date(substr(time, 1, 8), 'dd/mm/rr')

-- 
Andrew - Wizzard

barnetaj_at_bp.com

David A. Owens <daveo_at_criticaldata.com> wrote in article
<34FC8A19.436E_at_criticaldata.com>...

> OK, I guess I'll have to cobble something together like:
>
> define ARCHIVE_LOG_DAYS=30
> select archive_name
> from v$log_history where
> sysdate - to_date(
> substr(time,1,6)||decode(substr(time,7,2),
> '98','1998','99','1999','00','2000','01','2001','02','2002',
> '03','2003','04','2004','05','2005','06','2006','07','2007',
> '08','2008','09','2009','10','2010','11','2011','12','2012',
> '13','2013','14','2014','15','2015','16','2016','17','2017',
> '18','2018','19','2019','20','2020','21','2021','22','2022','##'),
> 'MM/DD/YYYY')
> > &ARCHIVE_LOG_DAYS;
Received on Wed Mar 04 1998 - 00:00:00 CET

Original text of this message