In Oracle, the input value of the date conversion report is insufficient for the Date Format Length.
In Oracle, the input value of the date conversion report is insufficient for the Date Format Length.
"The input value is not long enough in the date format" reported in Oracle for date conversion"
Select (select j. jgmc from t_zzjg j where j. jtpd = t. jtpd) jgmc,
T. jtpd,
Sum (t. jcj) jcj,
Sum (t. sa) sa,
Sum (t. la) la,
Sum (t. ajbl) ajbl,
Sum (t. xsqzcs) xsqzcs,
Sum (t. sacw) sacw,
Sum (t. jgzx) jgzx,
Sum (t. zfgz) zfgz,
Sum (t. jjclaj) jjclaj,
Sum (t. zs) zs
From t_fxyp_zfycfbtj t
Where t. rq between to_date (2013-01-18, 'yyyy-MM-DD ') and
To_date (2013-07-18, 'yyyy-MM-DD ')
And exists (select z. jtpd
From t_zzjg z
Where (z. dwlx = 'sj 'or z. sjjtpd is null)
And z. jtpd = t. jtpd)
Group by t. jtpd
Order by t. jtpd
Correct statement
Select to_date ('2017-05-06 12:05:03 ', 'yyyy-mm-dd hh24: mi: ss') from dual
Select to_date ('1970-05-06 ', 'yyyy-mm-dd hh24: mi: ss') from dual
Select to_date ('1970-05-06 ', 'yyyy-mm-dd') from dual
This query statement causes this reason because in the to_date () method, the date entered earlier must be enclosed in single quotation marks.
,