[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Date format from YYYYDDD TO DD-MON-YYYY
- Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY
- From: Raja Gade <rgade@ACS.UWA.EDU.AU>
- Date: Wed, 6 Jan 1999 18:42:33 +0800
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