Hello everybody,
We are working with Signavio PI and we have a problem with date conversion. We use the same syntax to convert the date in another client but in this one we have some problems. For context, we extract the data using an ABAP extractor in the SAP client. The return is the tables in CSV format.
Below is the syntax:
SELECT
BELNR,
CPUDT,
CPUTM,
CAST(parse_datetime((BKPF.cpudt||' '||BKPF.cputm), 'yyyyMMDD HHmmSS') AS TIMESTAMP) AS "CPUDT_TRANSFORMADO"
FROM BKPF
WHERE AWKEY = '51071021632022'
Return:
BELNR - CPUDT - CPUTM - CPUDT_TRANSFORMADO
5107102163 - 20221230 - 133625 - 2022-01-30 13:36:00.250
The issue is that the trasnformed CPUDT is not the one that we need.
Thanks, best regards.