ORA-01830: date format picture ends before converting entire input string
SQL&gt; alter session set nls_Date_format = 'DD-MON-YY HH24:MI:SS';

Session altered.

SQL&gt; select trunc(sysdate, 'DD') + 13/24 from dual;

TRUNC(SYSDATE,'DD'
------------------
29-AUG-15 13:00:00