Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    1

    Unanswered: error (247) arithmetic overflow during implicit conversion of VARCHAR value

    I am getting the following error:

    error (247) arithmetic overflow during implicit conversion of VARCHAR value '01/01/2010' to a DATETIME field.

    when I execute the following proc with two date parameters:

    EXEC somedb.dbo._p_proc '01/01/2010', '01/31/2010'

    Parameters are: @start_date DATETIME, @end_date DATETIME.

    I am not sure what the problem is?

  2. #2
    Join Date
    Jun 2010
    Posts
    51
    Please paste the full code. Only that can help.

  3. #3
    Join Date
    Feb 2009
    Location
    Prague
    Posts
    17
    It looks like you values are not in correct format for datetime type.
    Check this, it may help.

    Entering datetime and smalldatetime data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •