SAP ABAP CDS Convert Date and Time from YYYYMMDD to DD/MM/YYYY Example

Create Date in format DD/MM/YYYY

      cast(
          concat_with_space(
             Concat(
               Concat(
                 Concat(substring(tstmp_to_dats(even_tstfr, even_zonfr, $session.client, 'NULL'), 5, 2), '/'),
                 Concat(substring(tstmp_to_dats(even_tstfr, even_zonfr, $session.client, 'NULL'), 7, 2), '/')
                     ),
               Substring(tstmp_to_dats(even_tstfr, even_zonfr, $session.client, 'NULL'), 1, 4)),       
            Concat(
               Concat(
                 Concat(substring(tstmp_to_tims(even_tstfr, even_zonfr, $session.client, 'NULL'), 1, 2), ':'),
                 Concat(substring(tstmp_to_tims(even_tstfr, even_zonfr, $session.client, 'NULL'), 3, 2), ':')
                     ),
               Substring(tstmp_to_tims(even_tstfr, even_zonfr, $session.client, 'NULL'), 5, 2)),1)
          as char19 preserving type) as EvenTstfrDateTime ,
      cast(
          concat_with_space(
             Concat(
               Concat(
                 Concat(substring(tstmp_to_dats(even_tstto, even_zonto, $session.client, 'NULL'), 5, 2), '/'),
                 Concat(substring(tstmp_to_dats(even_tstto, even_zonto, $session.client, 'NULL'), 7, 2), '/')
                     ),
               Substring(tstmp_to_dats(even_tstto, even_zonto, $session.client, 'NULL'), 1, 4)),       
            Concat(
               Concat(
                 Concat(substring(tstmp_to_tims(even_tstto, even_zonto, $session.client, 'NULL'), 1, 2), ':'),
                 Concat(substring(tstmp_to_tims(even_tstto, even_zonto, $session.client, 'NULL'), 3, 2), ':')
                     ),
               Substring(tstmp_to_tims(even_tstto, even_zonto, $session.client, 'NULL'), 5, 2)),1)
          as char19 preserving type) as EvenTsttoDateTime