查询当前系统时间在开始时间和结束时间之间的数据:
select field
from [表名称]
where is_show = 0
and show_start_date <= TO_CHAR(current, '%Y-%m-%d %H:%M:%S')
and show_end_date >= TO_CHAR(current, '%Y-%m-%d %H:%M:%S')
order by show_end_date
查询当前系统时间在开始时间和结束时间之间的数据:
select field
from [表名称]
where is_show = 0
and show_start_date <= TO_CHAR(current, '%Y-%m-%d %H:%M:%S')
and show_end_date >= TO_CHAR(current, '%Y-%m-%d %H:%M:%S')
order by show_end_date