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