Re: Date format from YYYYDDD TO DD-MON-YYYY

["Ranade, Sameer" <sranade@BRISHOSP.CHIME.ORG>]

Hi Raja,

        U can use the same SQL inside SQR to get required formatting.

begin-select
TO_CHAR(TO_DATE($dtin ,'YYYYDDD'),'DD-MON-YYYY') &dtout
 move &dtout to $dtout
FROM DUAL
end-sql


HTH,
-Sameer

-----Original Message-----
From: Raja Gade [mailto:rgade@ACS.UWA.EDU.AU]
Sent: Wednesday, January 06, 1999 5:43 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY


I am trying to convert the date format from yyyyddd to dd-mon-yyyy in sqr.

For example
        198345 to  11-DEC-1998

In oracle the solution is

SQL> SELECT TO_CHAR(TO_DATE('1998345','YYYYDDD'),'DD-MON-YYYY') FROM DUAL;

TO_CHAR(TO_
-----------
11-DEC-1998

Can someone help me in modifying the date format from yyyyddd to
dd-mon-yyyy format in SQR

I am using SQR ver 3.0 ,Oracle Database & peoplesoft 6 financials.


Raja