select * from train_schedule where sysdate between start_date-30/24*60 and end_date
时间如果是'23:56'这样的字串,就这样改一下:select * from train_schedule where to_date( to_char(sysdate,'HH24:MI'),'HH24:MI') between to_date(start_date, 'HH24:MI')-30/24*60 and to_date(end_date, 'HH24:MI')
where sysdate between start_date-30/24*60 and end_date
where to_date( to_char(sysdate,'HH24:MI'),'HH24:MI')
between
to_date(start_date, 'HH24:MI')-30/24*60
and to_date(end_date, 'HH24:MI')
这样,你想怎么写就怎么写,查找方便多了