Oracle 时间 MM-dd形式转换
时间:2022-03-14 03:50
SELECT TO_CHAR( SYSDATE,‘MM-dd‘) AS beginTime,TO_CHAR( TO_DATE(MAX(C.SUBSCRIBE_DATE),‘YYYY-MM-dd‘),‘MM-dd‘) AS endTime from TableName
时间:2022-03-14 03:50
SELECT TO_CHAR( SYSDATE,‘MM-dd‘) AS beginTime,TO_CHAR( TO_DATE(MAX(C.SUBSCRIBE_DATE),‘YYYY-MM-dd‘),‘MM-dd‘) AS endTime from TableName