–postgresql 写法
and to_char(时间字段::timestamp,‘hh24mi’) between ‘0800’ and ‘2000’
substr(c.时间字段, 12,5 )between ‘08:00’ and ‘20:00’,
–oracle 写法
replace(substr(c.时间字段, 12,5),‘:’) between ‘0800’ and ‘2000’
–postgresql 写法
and to_char(时间字段::timestamp,‘hh24mi’) between ‘0800’ and ‘2000’
substr(c.时间字段, 12,5 )between ‘08:00’ and ‘20:00’,
–oracle 写法
replace(substr(c.时间字段, 12,5),‘:’) between ‘0800’ and ‘2000’