how to handle date format

See more:

Oracle

hi all good morning..

i have tried to update a table by using date comparison like below syntax.

update table_name set employee_salary=100000 where emp_id='121'
and to_char(to_date(JOIN_DATE,'DD-MON-YY HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') < to_char(TO_DATE(V_JOIN_DATE,'YYYY-MM-DD HH24:MI:SS:SSSSS'),'YYYY-MM-DD HH24:MI:SS');


in the above query join_date in the table is DATE type and V_JOIN_DATE is varchar2(50).


for the above query i am getting below error.

ORA-01836: hour conflicts with seconds in day
01836. 00000 -  "hour conflicts with seconds in day"
*Cause:
*Action:

i have tried to select date by using below query

SELECT TO_DATE('2013-09-18 05:32:54:00000','YYYY-MM-DD HH24:MI:SS') FROM DUAL;

but here also getting same below error.

ORA-01830: date format picture ends before converting entire input string
01830. 00000 -  "date format picture ends before converting entire input string"
*Cause:
*Action:

but i need compare join_date upto 2013-09-18 05:32:54.

is there any solution to solve the above errors and to get mentioned date format.