DB2 系統日期轉太陽曆

--系統日轉太陽曆

SELECT varchar(left(Year(CURRENT DATE), 2) - 19) || 

       varchar(right(Year(CURRENT DATE), 2)) || 

       varchar(right(digits(DAYOFYEAR(CURRENT DATE)), 3))

FROM table

--上月1日太陽曆
SELECT varchar(left(Year(last_day(CURRENT DATE - 2 MONTH) + 1 day), 2) - 19) || 

       varchar(right(Year(last_day(CURRENT DATE - 2 MONTH) + 1 day), 2)) || 

       varchar(right(digits(DAYOFYEAR(last_day(CURRENT DATE - 2 MONTH) + 1 day)), 3)) 

FROM table