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:

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

    • 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:
    4245
  • Date Created
    Thursday, April 21, 2022
  • Last Updated
    Thursday, April 21, 2022
  • This Article Has been Viewed
    309 times
  • Short Desc
    Using date format in SQL Server with the wrong interval will give the error that Invalid parameter 1 specified for datediff.
  • Details
    When running code in SQL Server you may encounter the following error.

     
    Microsoft OLE DB Provider for SQL Server error '80040e14'
    Invalid parameter 1 specified for datediff.
    /Load.asp, line 115
  • Recreate Issue
    In Access Database we use the following code with DateDiff to format our date or time.
    DATEDIFF('s', LoadDate, now()) as timestamps
  • Resolve Issue
    Unlike in Microsoft Access database, in SQL Server we use the entire word, instead of its letter.

    In SQL Server we use the following code with DateDiff to format our date or time.
    DATEDIFF(second, LoadDate, getdate()) as timestamps


Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles