mysqlでint方の年・月・日をdateに変換して、現在日よりを求める

SELECT CAST(concat(year,'-',month,'-',day) AS DATE) FROM `tbl_calendar` WHERE CAST(concat(LPAD(year, 4, '0'),'-',LPAD(month, 2, '0'),'-',LPAD(day, 2, '0')) AS DATE) >= CURDATE()

丸数字・○数字を数値文字参照形式 EUC=JP

①
②
③
④
⑤
⑥
⑦
①
②
③
④
⑤
⑥

postgres レコード年項目の値が存在したら、CASE文にて経過年数を表示

select
    m_i_age_year,
    CASE WHEN m_i_age_year = ''  THEN 0
         WHEN m_i_age_year <> '' THEN to_number(TO_CHAR(current_timestamp, 'yyyy'), '0000000000')-to_number(m_i_age_year, '0000000000')
    END  AS m_i_age_year_course_label
from tbl_estate_article;

postgresでの方変換とケース文

select
    CASE WHEN m_i_age_year = ''  THEN seq/100
         WHEN m_i_age_year <> '' THEN to_number(m_i_age_year, '0000000000')
    END  AS m_i_age_year
from tbl_estate_article;