KB440435: The error "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" encountered when configuring the MicroStrategy Intelligence Server if a SQL Server is
![SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2 - SQL Authority with Pinal Dave SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/datetimecs1.gif)
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2 - SQL Authority with Pinal Dave
![sql server - When inserting the varchar value into the datetime field, it throws conversion error - Database Administrators Stack Exchange sql server - When inserting the varchar value into the datetime field, it throws conversion error - Database Administrators Stack Exchange](https://i.stack.imgur.com/ieU7s.png)
sql server - When inserting the varchar value into the datetime field, it throws conversion error - Database Administrators Stack Exchange
![SQL SERVER - Get Time in Hour:Minute Format from a Datetime - Get Date Part Only from Datetime - SQL Authority with Pinal Dave SQL SERVER - Get Time in Hour:Minute Format from a Datetime - Get Date Part Only from Datetime - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/datetime2008.jpg)
SQL SERVER - Get Time in Hour:Minute Format from a Datetime - Get Date Part Only from Datetime - SQL Authority with Pinal Dave
![sql server - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value - Database Administrators Stack Exchange sql server - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value - Database Administrators Stack Exchange](https://i.stack.imgur.com/pXFNO.png)
sql server - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value - Database Administrators Stack Exchange
![ERROR: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. | Rochcass ERROR: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. | Rochcass](https://rochcass.files.wordpress.com/2015/03/region.png)
ERROR: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. | Rochcass
![sql server - Conversion of a varchar data type to a datetime data type resulted in an out-of-range value - Database Administrators Stack Exchange sql server - Conversion of a varchar data type to a datetime data type resulted in an out-of-range value - Database Administrators Stack Exchange](https://i.stack.imgur.com/CzBXU.png)