Re: 2 month rolling average/sql*plus
From: Jerry Bull <gbbull_at_denitqm.uswc.uswest.com>
Date: 1995/08/08
Message-ID: <408aai$n6r_at_borg.it.uswc.uswest.com>#1/1
Received on Tue Aug 08 1995 - 00:00:00 CEST
Date: 1995/08/08
Message-ID: <408aai$n6r_at_borg.it.uswc.uswest.com>#1/1
farnham_at_spot.Colorado.EDU (Jenny Farnham) wrote:
>Select to_char(sysdate,'MON') - 1 from dual;
>
Use:
Select to_char(sysdate, 'MM') - 1 from dual;
This results in the format of the date as 08 instead of AUG like the 'MON' format does.
Jerry.
Jerry Bull, Sr. MTS voice: (303) 624-3073 U S WEST Information Technologies fax: (303) 624-8462 931 14th Street, Suite 920 email: gbbull_at_denitqm.mnet.uswest.comDenver, CO 80202
Received on Tue Aug 08 1995 - 00:00:00 CEST