SQL Server not liking dates in YYYY-MM-DD format
- by greenfingers
Is there a setting in SQL Server which will persuade it to accept 'yyyy-mm-dd' style dates in a query.
Got queries which are running fine on most of our SQL servers one box running Microsoft SQL Server 2005 Developer doesn't like them. This is the error:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
YYYYMMDD works fine