Oracle处理日期时间

where contdate=to_char(to_date(20130220,'yyyyMMdd'),'yyyyMMdd') //hhmmss HH:MMSS 式可以自己定义 conttime between to_char(to_date(#startTime#,'hhmiss'),'hhmiss') and to_char(to_date(#endTime#,'hhmiss'),'hhmiss')

where contdate=to_char(to_date(20130220,'yyyyMMdd'),'yyyyMMdd')

//hhmmss HH:MMSS 格式可以自己定义

conttime between to_char(to_date(#startTime#,'hhmiss'),'hhmiss') and to_char(to_date(#endTime#,'hhmiss'),'hhmiss')