CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • SQL Server Invalid parameter 1 specified for datediff, Microsoft OLE DB Provider for SQL Server error '80040e14'

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    130
  • Date Created
    Saturday, April 2, 2011
  • Last Updated
    Wednesday, June 20, 2012
  • This Article Has been Viewed
    3877 times
  • Short Desc
    When using a datediff within your SQL Queries, you have to make sure that the parameters that you are using are correctly written and used.
  • Details
    When you have to use the DateDiff within your SQL Queries (Select Statements), make sure that you use the parameters correctly, if not you will receive the following error within the SQL Server Management Studio.

     
    Msg 1023, Level 15, State 1, Line 1
    Invalid parameter 1 specified for datediff.


    Within ASP you will receive the following Error:

     
    Microsoft OLE DB Provider for SQL Server error '80040e14'
    Invalid parameter 1 specified for datediff.
    /StatComs.asp, line 14
  • Recreate Issue
    To recreate this issue.

    <%
    sql.commandtext="select datediff('s', MyDate, getdate()) as date from table"
    %>


    The above will give you the error due to the single quotes around the s
  • Resolve Issue
    To resolve this issue.

    <%
    sql.commandtext="select datediff(s, MyDate, getdate()) as date from table"
    %>


    As you can see in the above statement, we have removed the single Quotes from the s from the statement.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles