04-13工作笔记

--注意点，要是时间刚好是0时0分0秒的话，就只显示年月日，不显示时分秒
SELECT TO_DATE('2020/1/1 00:00:00','YYYY/MM/DD HH24:MI:SS') AS D FROM DUAL;
>>>
2020/1/1

SELECT TO_DATE('2020/1/1 00:00:01','YYYY/MM/DD HH24:MI:SS') AS D FROM DUAL;
>>>
2020/1/1 0:00:01

--将时间保存为指定的字符串格式
SELECT TO_CHAR(TO_DATE('2020/1/1 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
               'YYYY/MM/DD HH24:MI:SS') AS D
  FROM DUAL;
>>>
2020/01/01 00:00:00