--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;