Show how many error messages have happened in the last 24 hours

SELECT COUNT(*) AS ERROR_MESSAGE_COUINT FROM ACTLOG WHERE SEVERITY = ‘E’ AND DATE_TIME> ‘YYYY-MM-DD HH:MM‘

WHERE
YYYY = Year
MM = Month
DD = Day
HH = Hour
MM = Month