select to_char(to_date(TIMESTAMP,'yyyy-mm-dd hh24:mi:ss'),'yyyy.mm.dd') t FROM MES_30MIN
oracle时间字符格式转换
最新推荐文章于 2023-12-26 14:42:10 发布
select to_char(to_date(TIMESTAMP,'yyyy-mm-dd hh24:mi:ss'),'yyyy.mm.dd') t FROM MES_30MIN