string(1031) "SQL-ERROR: -- appointment_list
      select
        a.ID_APPOINTMENT,
        a.ID_TYPE_APPOINTMENT,
        ta.NAME_TYPE_APPOINTMENT,
        to_char(a.DATE_START, 'DD.MM.YYYY') as DATE_START,
        to_char(a.DATE_START, 'HH24:MI') as TIME_START,
        to_char(a.DATE_END, 'DD.MM.YYYY') as DATE_END,
        to_char(a.DATE_END, 'HH24:MI') as TIME_END,
        a.IS_DAILY,
        a.TITLE,
        a.INFO,
        a.IS_ACTIVE,
        a.IS_CONFIRMED
      from
        APPOINTMENT a,
        TYPE_APPOINTMENT ta
      where
        a.ID_TYPE_APPOINTMENT = ta.ID_TYPE_APPOINTMENT and
        a.IS_ACTIVE = 1 and
        a.IS_CONFIRMED = 1 and
        (a.DATE_START < to_date('2021-01-26', 'YYYY-MM-DD') and a.DATE_END >= to_date('2021-01-26', 'YYYY-MM-DD') or
         a.DATE_START >= to_date('2021-01-26', 'YYYY-MM-DD') and a.DATE_END <= to_date('2022-01-27', 'YYYY-MM-DD') or
         a.DATE_START <= to_date('2022-01-27', 'YYYY-MM-DD') and a.DATE_END > to_date('2022-01-27', 'YYYY-MM-DD'))
      order by
        a.DATE_START"
RAT-Pack Baldauf
GB Flag
RAT
Di. 26. Jan 2021 06.11 Uhr
string(584) "SQL-ERROR: -- link_list
      select
        l.ID_LINK,
        l.TITLE,
        l.URL,
        l.SUBTITLE,
        l.DATE_ENTRY as DATETIME_ENTRY_R,
        to_char(l.DATE_ENTRY, 'DD.MM.YYYY') as DATE_ENTRY,
        to_char(l.DATE_ENTRY, 'HH24:MI:SS') as TIME_ENTRY,
        l.DATE_LAST_CHANGE as DATETIME_LAST_CHANGE_R,
        to_char(l.DATE_LAST_CHANGE, 'DD.MM.YYYY') as DATE_LAST_CHANGE,
        to_char(l.DATE_LAST_CHANGE, 'HH24:MI:SS') as TIME_LAST_CHANGE
      from
        LINK l
      where
        l.IS_ACTIVE is true
      order by
        l.DATE_ENTRY desc
      limit 15"

Die nächsten Termine

Termin Typ Beschreibung

Hier kannst Du selbst einen Termin vorschlagen