SELECT HOUR(timestamp_column) AS log_hour,
       MINUTE(timestamp_column) AS log_minute,
       SECOND(timestamp_column) AS log_second
FROM log_entries;