Oracle SQL: Format Date and Determine Shift (Day/Night) from Timestamp

SELECT a.*, \n TO_CHAR(a.create_time, 'yyyy/mm/dd') create_time1,\n (CASE\n WHEN TO_CHAR(SUBSTR(a.create_time, 11, 2), 'HH24:mi') > 8\n THEN 'Day Shift'\n ELSE 'Night Shift'\n END) AS shift\nFROM xx_oqc_ng_qh a