Julian format date in SQLRPGLE

[InfraRed]

SET LSTCOUNT = DATE(DIGITS( DECIMAL(:ConvertDate +1900000,7,0)))
ConvertDate is of Julian format, i am trying to convert to a regular date in file, but it doesnt accept it: "column or variable LSTCOUNT not compatible. "
I changed the field LSTCOUNT from L type to zoned 8,0 - same result
What type should it be or what other options?
Thanks.

[B.Hauser]

1. If you have the data type L it is already a date. No need to convert anything. You can only format the date, i.e. convert into a character representation of a date. For converting a date or a timestamp into a character representation, in almost any format use the VARCHAR_FORMAT scalar function.
https://www.ibm.com/docs/en/i/7.4?topic=functions-varchar-format
2. The format of a julian date is 4 digit year and 3 digit (running) day in the year.
Here are several ways to covert a character or numeric date in the Julian Format into a real date

With x (DateNum, DateChar) as (Values(Cast(2022123 as Dec(7, 0)), Cast('2022125' as Char(7))))
Select x.*, Date(Digits(DateNum)),
Date(Timestamp_Format(Digits(DateNum), 'YYYYDDD')),
Date(DateChar),
Date(Timestamp_Format(DateChar, 'YYYYDDD'))
from x;

Birgitta