Hello,
I tried to automatically generate a .ics file to send it to our employees, but there is something wrong with the format.
My code PL/SQL code:
SELECT
(
(SELECT
TO_CHAR(TO_DATE((SELECT available_date FROM zb_dates_quick WHERE id = 1), 'DD.MM.YY'), 'YYYY-MM-DD')
FROM dual)
|| 'T' ||
(SELECT start\_time FROM zb\_timeslots\_quick WHERE id = 1) || ':00'
) as ICSFormat
FROM dual;
Can anybody help me with writing this to work, always when I sent it than apex displays that something ends before it is able to process. I don't know what is wrong about this format, so is it false to transfer it to a string? I think the isc format need this format: 2021-01-27T13:59:43