8 Replies Latest reply: Jan 28, 2015 9:45 AM by Jan Heinrichsdorff RSS

    month & year from date

      Hi Experts

       

      Hoe can I script to receive a month and a year out of a field containing a date? I tried the following which did not work:

       

      SQL SELECT jobnr,

          datum,

          Month (datum)& Year (datum) as StundenMonat,

          stunden,

          stundenart,

          marnr as MitarbeiterStunden

      FROM EASY.stunden;

       

      I would like to have: 01 2014, 02 2014 e.g.

       

      Thank you for your help!

       

      Jan