CHANGEDAT

SELECT
  TO_CHAR(afaktura.CREATEDAT, 'DD.MM.YYYY HH24:MI:SS') AS CREATEDAT,
  TO_CHAR(afaktura.CHANGEDAT, 'DD.MM.YYYY HH24:MI:SS') AS CHANGEDAT,
  afaktura.EXTFAKTURANR
FROM atour
LEFT JOIN atasend ON atour.nr = atasend.tournr
LEFT JOIN ASDGABRECHNUNG ON atasend.nr = ASDGABRECHNUNG.ATAID
LEFT JOIN afaktura ON ASDGABRECHNUNG.FK_IDAFAKTURA = afaktura.IDAFAKTURA
WHERE atour.TOURNUMMER = 496047;