SQL Error:
MySQL server has gone away
SELECT *, DAY
(ev_dt
) as start_day, MONTH
(ev_dt
) as start_month, Year
(ev_dt
) as start_year, DAY
(ev_dt_end
) as end_day, MONTH
(ev_dt_end
) as end_month, Year
(ev_dt_end
) as end_year
FROM event
WHERE ev_dt between '2024-04-01'
AND '2024-04-31'
OR ev_dt_end between '2024-04-01'
AND '2024-04-31'
OR (ev_dt < '2024-04-01'
AND ev_dt_end > '2024-04-31'
) order by ev_dt
SQL Error:
MySQL server has gone away
SELECT tn_notice from today where YEAR
(tn_dt
)='2024'
AND MONTH
(tn_dt
)='04' and DAY
(tn_dt
)='19' order by tn_crt_dt desc limit 1