How to use the SQL Server DateTime parameter to avoid the "Invalid date" error in Visual C++ (156139)

The information in this article applies to:

Microsoft Visual C++, 32-bit Enterprise Edition 4.2
Microsoft Visual C++, 32-bit Enterprise Edition 5.0
Microsoft Visual C++, 32-bit Enterprise Edition 6.0
Microsoft Visual C++, 32-bit Professional Edition 4.2
Microsoft Visual C++, 32-bit Professional Edition 5.0
Microsoft Visual C++, 32-bit Professional Edition 6.0
Microsoft Visual C++, 32-bit Learning Edition 6.0

This article was previously published under Q156139

SUMMARY

If you run a SQL Server stored procedure that has a datetime type parameter, you need to provide the value in a specific format or you get the following error:

22008[Microsoft][ODBC SQL Server Driver]Invalid date

Visual C++, Enterprise Edition, version 5.0 can also give "Invalid timestamp" error for some combination of date and time formats.

MORE INFORMATION

Create the following stored procedure in a SQL Server datasource:

      CREATE PROCEDURE GetDateTime @dt datetime AS
      RETURN

Execute the Stored Procedure.

   The "Execute Stored Procedure" window asks for parameters. The following
   are the only acceptable formats:

      yyyy-mm-dd
      yyyy-mm-dd hh:mm:ss

All other formats generate the above error message.

Modification Type:	Major	Last Reviewed:	6/2/2005
Keywords:	kbinfo kbDatabase kbEEdition kberrmsg kbhowto kbProgramming kbSQLProg KB156139 kbAudDeveloper