Jump to content

jdelamarre

New Members
  • Posts

    1
  • Joined

  • Last visited

jdelamarre's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. you can create a function: /* ************************************************** */ SET PATH "QSYS","QSYS2","QGPL" ; CREATE FUNCTION QGPL.TO_DATE ( PARAM_DATE DECIMAL(8, 0) ) RETURNS DATE LANGUAGE SQL SPECIFIC QGPL.TO_DATE DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN DATE ( CASE WHEN PARAM_DATE IS NULL OR PARAM_DATE = 0 THEN '9999-01-01' ELSE DATE ( INSERT ( INSERT ( PARAM_DATE , 5 , 0 , '-' ) , 8 , 0 , '-' ) ) END ) ; /* ************************************************** */ and use WEEK() function
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.