oracle用to_date函数转
select * from t99_stat_index_cd where to_date(start_tm,'HH24:mi:ss') > to_date('19:00:00','HH24:mi:ss') and to_date(end_tm,'HH24:mi:ss') < to_date('20:00:00','HH24:mi:ss') and stat_index_type_cd = '0005' ;
MYSQL用time函数转
select * from t99_stat_index_cd where TIME(START_TM) > TIME('19:00:00') and TIME(END_TM) < TIME('20:00:00') and STAT_INDEX_TYPE_CD = '0005';
1min目标场景问卷
立即参与
