--0点显示
select b.vcieffectivedate as a ,to_char(b.vcieffectivedate,'yyyy-mm-dd hh24:mi:ss') as b
from ghresbase b
where b.vcieffectivedate is not null;
--0点显示
select b.vcieffectivedate as a ,to_char(b.vcieffectivedate,'yyyy-mm-dd hh24:mi:ss') as b
from ghresbase b
where b.vcieffectivedate is not null;
转载于:https://www.cnblogs.com/wuyuwuyueping/p/9468616.html