5 Replies Latest reply: Nov 7, 2012 5:28 AM by Stefan Wühl RSS

    Conversion field format

    ali ceyli

      Hello everyone,

      In order to use in qw ,

      I must convert number field into date format

      I get data from oracle db number format is : YYYYWW and also date format should be YYYYWW


      to_date(to_char(ORIGIN_YEAR_WEEK),'YYYYWW') sql auery does not work


      Best regards