select substring('2021-10-27 01:27:15',12,length('2021-10-27 01:27:15')) ; -- 01:27:15
select substring('2021-10-27 01:27:15',12,length('2021-10-27 01:27:15')) < '23:59:59' -- true
select substring('2021-10-27 01:27:15',12,length('2021-10-27 01:27:15')) between '06:00:00' and '23:59:59' -- false
select '01:27:15' > '06:00:00' ; -- false
select '01:27:15' < '23:59:59' ; -- true
select '01:27:15' > '06:00:00' and '01:27:15' < '23:59:59' ; -- false
select '07:27:15' > '06:00:00' and '07:27:15' < '23:59:59' ; -- true
end



