What language setting are you using? For example:

SELECT CAST('25/08/14' as datetime)

SELECT CAST('08/25/14' as datetime)

Can give you different results based on your language setting for the server.