SELECT TEST_TIME,SECTION,
CASE
WHEN (SECTION<'0730'AND SECTION>'0000') OR ( SECTION<'2400'AND SECTION>'1930') THEN 'NIGHT'
ELSE 'DAY'
END
FROM (SELECT TEST_TIME, TO_CHAR(TEST_TIME, 'HH24MI') SECTION
FROM R_TEST_T ) R;
SELECT TEST_TIME,SECTION,
CASE
WHEN (SECTION<'0730'AND SECTION>'0000') OR ( SECTION<'2400'AND SECTION>'1930') THEN 'NIGHT'
ELSE 'DAY'
END
FROM (SELECT TEST_TIME, TO_CHAR(TEST_TIME, 'HH24MI') SECTION
FROM R_TEST_T ) R;