------------------------------ Commands Entered ------------------------------
SELECT jt_dt
     , SUBSTR(jt_dt, 6, 5) || '-' || SUBSTR(jt_dt, 1, 4) expression_1
     , TRANSLATE('ef-gh-abcd', jt_dt, 'abcd-ef-gh')      expression_2
     , REPLACE(CHAR(DATE(jt_dt), USA), '/', '-')         expression_3
     , RIGHT(jt_dt, 5) || '-' || LEFT(jt_dt, 4)          expression_4
  FROM (VALUES CAST('2002-04-18' AS CHAR(10) ) ) AS s(jt_dt)
;
------------------------------------------------------------------------------

JT_DT      EXPRESSION_1 EXPRESSION_2 EXPRESSION_3 EXPRESSION_4         
---------- ------------ ------------ ------------ ---------------------
2002-04-18 04-18-2002   04-18-2002   04-18-2002   04-18-2002           

  1 record(s) selected.