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