I have a stored proc which inserts date time. It inserts successfully. But 2 PM afternoon, it gives me date time converion error. The next day it works fine. But daily after 2 PM, it gives error converting varchar to date time error
The weird thing is its showing this error only in one of the server, which is live server. Whereas it works fine else where in other servers.
The server level setting is US English, the logins used are US English.
Any idea where to look pls?