求大神。指点、
select x.* from (Select rownum rowno, z.* from (
select a.zhongduanid,
b.addressname,
c.display_name as zhongduanxinhao,
a.zhongduanbianhao,
a.simkahao,
a.dengjiriqi,
a.youxiaoriqi,
decode(a.zhuangtai, 0, '停用', '正常') as zhuangtai,
a.zuihouxiugaishijian,
a.banbenhao
from t_zhongduan a
left join t_address b
on a.quhuaid = b.addressid
left join mansys.t_dict_item c on a.zhongduanxinghaodm=CAST(c.fact_value as char(3))
where 1 = 1 and dict_code='dm_xb'
这是我的SQL语句,数据库表里面有个字段 dengjiriqi ,现在我想查的是 dengjiriqi,与服务器上的时间一样的数据。在SQL语句上该怎么改。