Forums » Code » SQL » The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

Previous | Next
Latest post 09-23-2008 12:22 PM by Nick. 0 replies.

  • 09-23-2008 12:22 PM

    • Nick
    • Top 10 Contributor
    • Joined on 04-28-2008
    • Posts 27

    The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

    Reply |Contact

     caused by incorrect formatting of date parameters in dynamic sql
    LM.ActivityDate >''' +  CONVERT(varchar(8),@StartDate,112) + '''

Page 1 of 1 (1 items) | RSS
Forums to discuss Microsoft ASP.Net Development and SQL
Powered by Community Server (Non-Commercial Edition), by Telligent Systems