日期格式化:
date_format(now(),'%Y-%m-%d %H:%i:%s')
update t_oa_wjmlxx t1 inner join t_oa_wjccxx t2 on t1.mlxxid=t2.parentid and t2.wjccxxid in ('2c90d8c35003b7eb015004187a0f0013') set t1.xgsj=now(), t1.xgr='admin'
select t.bh,
t.clsj,
t.dm,
t.fjdz,
t.isshpt,
t.jlnf,
t.lyzt,
t.nr,
t.sldw,
t.title,
date_format(t.tjsj, '%Y-%m-%d') as tjsj,
t.tjzsf,
t.twzxm,
d.name,
z.zdmc as ztmc,
(select case
when t.lyzt = '00007' then
'green.jpg'
else
s.tblj
end) as tblj
from t_ygfw_message t
left join t_ygfw_dept d
on t.sldw = d.dm
left join sjzd z
on t.lyzt = z.zddm
left join t_ygfw_sjdcsb s
on (unix_timestamp(now()) - unix_timestamp(t.tjsj)) / (60 * 60 * 24) + 0.5 >=
s.mintime
and (unix_timestamp(now()) - unix_timestamp(t.tjsj)) / (60 * 60 * 24) + 0.5 <
s.maxtime
where 1 = 1
order by t.tjsj desc, t.bh asc;
mysql查詢行号:
rownum:[email protected]+1,