HOWTO: Use the SQL Server DateTime Parameter

Last reviewed: June 26, 1997
Article ID: Q156139

The information in this article applies to:

Microsoft Visual C++, Enterprise Edition, versions 4.2, 5.0

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.

Keywords : kberrmsg kbprg VCEntIss
Technology : kbMfc
Version : 4.2 5.0
Platform : NT Windows
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 26, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.