phoenix根据日期范围查询

2.phoenix按照日期字段进行查询的时候需要注意日期转换格式字符串需要区分大小写，否则报错！！！！！！！！！

例子：select * from PHX_SVC_PC_BASIC_INFO where PKID=123 and UID='123' and (uid='521' or uid='695') and (TO_CHAR(OP_DATE,'yyyy-MM-dd HH:mm:ss') between '2015-11-01-00:00:00' and '2015-11-27-17:00:00')