Only do a conversion using the proper mask for to_date. Utilize the NLS_DATE_FORMAT = 'YYYY-MM-DD hh:mi:ss'

Cheers

Angel