SQL Server将nvarchar转换为datetime数据类型 [英] sql server converting nvarchar to datetime datatype

问题描述

你好，

当我更新源字段数据类型为nvarchar且目标字段数据类型为datetime的表时，其给出错误

将表达式转换为数据类型为datetime的算术溢出错误.
该声明已终止.


请解决此问题.

Manish

Hello,

when i am updating table whose source field datatype is nvarchar and target field datatype is datetime then its give error

Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.


Please resolve this issue.

Manish

推荐答案

看起来像链接1 [链接2 [

Looks like Google[^] has lots of posts to help you out!

First 2:
Link 1[^]
Link 2[^]

这篇关于SQL Server将nvarchar转换为datetime数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！