用下面的查询语句获得数据的时候出现时分秒丢失现象。。怎么解决, 丢失数据的是pr.createtime字段。
我是使用DataList进行分页的。这是我xml:<select id="selectResult" resultClass="java.util.HashMap">
select *
from (select tab.*, rownum rn
from (
select pr.user_id,
pr.loginno,
pv.st,
pv.stname,
pr.pno,
pp.cname,
wl.order_req_tran_seq,
(case
when pp.category = 1 then
'一等奖'
when pp.category = 2 then
'二等奖'
when pp.category = 3 then
'三等奖'
when pp.category = 4 then
'幸运奖'
when pp.category = 5 then
'超级大奖'
end) category,
pr.CREATETIME CREATETIME
from (select * from wing_result t where t.present_id >0) pr left join wing_present pp on pr.present_id = pp.id
left join wing_province pv on substr(pr.user_id,0,2) = pv.st left join wing_lottery wl on pr.bak2=wl.order_req_tran_seq
where
1=1
<isNotEmpty prepend=" AND " property="userId">pr.USER_ID like ltrim(rtrim(#userId#))||'%'</isNotEmpty>
<isNotEmpty prepend=" AND " property="cname">pp.cname like ltrim(rtrim(#cname#))||'%'</isNotEmpty>
<isNotEmpty prepend=" AND " property="bak2">pr.bak2=ltrim(rtrim(#bak2#))</isNotEmpty>
<isNotEmpty prepend=" AND " property="loginno">pr.loginno=ltrim(rtrim(#loginno#))</isNotEmpty>
<isNotEmpty prepend=" and " property="st">pv.st=ltrim(rtrim(#st#))</isNotEmpty>
<isNotEmpty prepend=" and " property="ptype">pp.ptype=ltrim(rtrim(#ptype#))</isNotEmpty>
<isNotEmpty prepend=" and " property="category">pp.category=ltrim(rtrim(#category#))</isNotEmpty>
<isNotEmpty prepend=" and " property="startTime">pr.createtime>=to_date(#startTime#,'yyyy-mm-dd hh24:ss:mi')</isNotEmpty>
<isNotEmpty prepend=" and " property="endTime"><![CDATA[ pr.createtime<=to_date(#endTime#,'yyyy-mm-dd hh24:ss:mi') ]]></isNotEmpty>
order by pr.CREATETIME desc
) tab where #lastrow# > rownum) where rn > #firstrow#
</select>
我是使用DataList进行分页的。这是我xml:<select id="selectResult" resultClass="java.util.HashMap">
select *
from (select tab.*, rownum rn
from (
select pr.user_id,
pr.loginno,
pv.st,
pv.stname,
pr.pno,
pp.cname,
wl.order_req_tran_seq,
(case
when pp.category = 1 then
'一等奖'
when pp.category = 2 then
'二等奖'
when pp.category = 3 then
'三等奖'
when pp.category = 4 then
'幸运奖'
when pp.category = 5 then
'超级大奖'
end) category,
pr.CREATETIME CREATETIME
from (select * from wing_result t where t.present_id >0) pr left join wing_present pp on pr.present_id = pp.id
left join wing_province pv on substr(pr.user_id,0,2) = pv.st left join wing_lottery wl on pr.bak2=wl.order_req_tran_seq
where
1=1
<isNotEmpty prepend=" AND " property="userId">pr.USER_ID like ltrim(rtrim(#userId#))||'%'</isNotEmpty>
<isNotEmpty prepend=" AND " property="cname">pp.cname like ltrim(rtrim(#cname#))||'%'</isNotEmpty>
<isNotEmpty prepend=" AND " property="bak2">pr.bak2=ltrim(rtrim(#bak2#))</isNotEmpty>
<isNotEmpty prepend=" AND " property="loginno">pr.loginno=ltrim(rtrim(#loginno#))</isNotEmpty>
<isNotEmpty prepend=" and " property="st">pv.st=ltrim(rtrim(#st#))</isNotEmpty>
<isNotEmpty prepend=" and " property="ptype">pp.ptype=ltrim(rtrim(#ptype#))</isNotEmpty>
<isNotEmpty prepend=" and " property="category">pp.category=ltrim(rtrim(#category#))</isNotEmpty>
<isNotEmpty prepend=" and " property="startTime">pr.createtime>=to_date(#startTime#,'yyyy-mm-dd hh24:ss:mi')</isNotEmpty>
<isNotEmpty prepend=" and " property="endTime"><![CDATA[ pr.createtime<=to_date(#endTime#,'yyyy-mm-dd hh24:ss:mi') ]]></isNotEmpty>
order by pr.CREATETIME desc
) tab where #lastrow# > rownum) where rn > #firstrow#
</select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货