01861 literal does not match format string

See more:

SQL

Oracle

I have a query to select last 5 vehicle are recently reported. which is stored in "VEHICLE_IN" table.

SELECT R.REG_NO FROM
   (SELECT G.REG_NO FROM VEHICLE_IN G
    INNER JOIN VEHICLE_MASTER M ON G.REG_NO=M.REG_NO
    WHERE to_date((IN_DATE||' '||IN_TIME),'YYYY-MM-DD HH24:MI') >= (SYSDATE-30/1440)
    AND M.VEHICLE_STAND='STAND1'
    ORDER BY G.IN_DATE DESC, G.IN_TIME DESC) R
   WHERE ROWNUM <= 5
   GROUP BY R.REG_NO ;

[Record format (VARCHAR2(20)): IN_DATE : '2016-03-21'; IN_TIME: '18:27']

The query returns an error

01861-literal-does-not-match-format-string

But the condition works in some other query.

Anybody please help me to find out the mistake..

What I have tried:

I have increase size of both IN_date and In_time fields to 50. Still error occurred. But

SELECT REG_NO,IN_DATE,IN_TIME FROM VEHICLE_IN WHERE TO_DATE((IN_DATE||' '||IN_TIME ),'YYYY-MM-DD HH24:MI') >= (SYSDATE-30/1440)  

this query working good.