Oracle-时间与字符串转换

复制代码
--UPDATE_TIME 是时间,直接转成字符串
SELECT to_char(MAX(UPDATE_TIME), 'yyyy-mm-dd hh24:mi:ss') as lastUpdateTime,
       to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') as accountTime
  FROM QLK_AREA;
  
-- LASTUPDATETIME 是字符串,先转成时间,再转成字符串
SELECT to_char(to_date(MAX(LASTUPDATETIME), 'yyyymmddhh24miss'),
               'yyyy-mm-dd hh24:mi:ss') as lastUpdateTime,
       to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') as accountTime
  FROM PSN_MZ_LHDJXX_BL;
复制代码

 

posted @   伍叶春  阅读(64870)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示