The error 'Conversion failed when converting date and/or time from character string.". ' is usually associated with language settings. Is the default language for the server\login\connection different between prod and test?

Just a thought...