Home Forums SQL Server 2008 T-SQL (SS2K8) Conversion failed when converting character string to smalldatetime data type. RE: Conversion failed when converting character string to smalldatetime data type.

  • Check the data types of date columns in your SELECT list

    I assume you have some column with CHAR or VARCHAR as their datatype, convert them to SMALLDATETIME or DATETIME


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/