Oracle working with to_date

Question

SELECT   TO_DATE (2014 || '.09.30', 'yyyy.mm.dd')
       - TO_DATE (2104 || '.07.01', 'yyyy.mm.dd')
          AS "Wtf",
       TO_DATE (2014 || '.09.30', 'yyyy.mm.dd') AS date_to,
       TO_DATE (2104 || '.07.01', 'yyyy.mm.dd') AS date_from
  FROM DUAL

回归-32781 2014/09/30/2104/07/01/

为什么我得到-32781?

谢谢. .

Answer 1

会是2104年而不是2014年吗?