-
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
-
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
-
Forum Rules
|
|