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')
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did98817