oracle 查询两个时间段的数据,该如何处理
oracle 查询两个时间段的数据
to_char(flow.fforwarddate,'YYYYMMDD')>'2015-04-10' and to_char(flow.fforwarddate,'YYYYMMDD')<'2015-04-15'
有数据却查不到值
------解决思路----------------------
你应用To_Date吧
再说了你to_char格式化也是错的呀 应是YYYY-MM-DD
to_char(flow.fforwarddate,'YYYYMMDD')>'2015-04-10' and to_char(flow.fforwarddate,'YYYYMMDD')<'2015-04-15'
------解决思路----------------------
你把这个where条件排除掉，看取到的数据时间在这个范围内不
------解决思路----------------------
to_char(flow.fforwarddate,'YYYY-MM-DD')>'2015-04-10' and to_char(flow.fforwarddate,'YYYY-MM-DD')<'2015-04-15'
to_char(flow.fforwarddate,'YYYYMMDD')>'2015-04-10' and to_char(flow.fforwarddate,'YYYYMMDD')<'2015-04-15'
有数据却查不到值
------解决思路----------------------
你应用To_Date吧
再说了你to_char格式化也是错的呀 应是YYYY-MM-DD
to_char(flow.fforwarddate,'YYYYMMDD')>'2015-04-10' and to_char(flow.fforwarddate,'YYYYMMDD')<'2015-04-15'
------解决思路----------------------
你把这个where条件排除掉，看取到的数据时间在这个范围内不
------解决思路----------------------
to_char(flow.fforwarddate,'YYYY-MM-DD')>'2015-04-10' and to_char(flow.fforwarddate,'YYYY-MM-DD')<'2015-04-15'