That is a funny one, as the convert is the same in the select and the where, so both should fail.

Would it be possible to post the DDL (CREATE TABLE script) form VP_EMPLOYEE and also some dummy data, to see if I can repro the error.