Results 1 to 2 of 2

Thread: Conversion of nvarchar to datetime. Is this possible??

  1. #1
    Mike Guest

    Conversion of nvarchar to datetime. Is this possible??

    The transaction_date is datetime and date1 is nvarchar.
    When I run the script:
    Insert into payment(transaction_date)
    Select convert (datetime, date1) from dep01

    I get the following message:

    Server: Msg 8115, Level 16, State 2, Line 1
    Arithmetic overflow error converting expression to data type datetime.
    The statement has been terminated.

    Thanks in advance, Mike

  2. #2
    HemantH Guest

    Conversion of nvarchar to datetime. Is this possible?? (reply)

    when converting into datetime provide the STYLE. Refer BOL

    CONVERT (data_type[(length)], expression [, style])



    ------------
    Mike at 8/22/00 11:10:07 AM

    The transaction_date is datetime and date1 is nvarchar.
    When I run the script:
    Insert into payment(transaction_date)
    Select convert (datetime, date1) from dep01

    I get the following message:

    Server: Msg 8115, Level 16, State 2, Line 1
    Arithmetic overflow error converting expression to data type datetime.
    The statement has been terminated.

    Thanks in advance, Mike

Posting Permissions

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