[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

On Wed, 6 Jan 1999, Ranade, Sameer wrote:
> Hi Raja,
>
> begin-select
> TO_CHAR(TO_DATE($dtin ,'YYYYDDD'),'DD-MON-YYYY') &dtout
>  move &dtout to $dtout
> FROM DUAL
> end-select

You can also use the SQR functions strtodate and datetostr :

  let $dtout = datetostr(strtodate($dtin,'YYYYDDD'),'DD-MON-YYYY')

HTH,
  Ray