SELECT CASE
WHEN to_number(to_char(SYSDATE, 'hh24')) BETWEEN 1 AND 15 THEN
'AM'
WHEN to_number(to_char(SYSDATE, 'hh24')) BETWEEN 15 AND 23 THEN
'PM'
END
FROM dual