插入数据报错！！！，急

[wunike]

用insert into 将一个表里的int型数据插入到另一张表里的datetime型数据里，我用cast先把int转换成datetime再插入，然后提示String or binary data would be truncated. 请帮忙解决谢谢！！！

[华夏小卒]

代码贴出来，看看

[pl_mm]

--超出範圍了吧
where isdate(轉換後的)=1

[华夏小卒]

insert into b select cast(ltrim(2009)+right('0'+ltrim(8),2)+right('0'+ltrim(8),2)as datetime)

[SQL77]

ISDATE(COL)=1
判断一下是否能转成时间型呀

[billpu]

数据超出了字段的长度,看看字段长度

[wunike]

insert into HRHolidayPolicy(hrHolidayPolicy, hrDate, hrDayOfWeek, hrCountedDays, hrInputUser, hrAction,hrHolidaytype)
select Holiday_Policy,cast(DATEADD(day, -693596,Date1) as datetime) , Day_of_week, Counted_days,'Nike','A', Description
FROM pip.dbo.PPHOLIDY

[SQL77]

截取了数据,

[SQL77]

Date1
能转成时间型吗

[wunike]

Date1 是int 如730855

[wunike]

用select cast(DATEADD(day, -693596,Date1) as datetime)
结果得到是时间没错呀

[SQL77]

[Quote=引用 10 楼 wunike 的回复:]
用select cast(DATEADD(day, -693596,Date1) as datetime)
结果得到是时间没错呀
[/Quote]
你DATE1都不能转成时间型??后面怎么转呀

[wunike]

select cast((Date1-693596) as datetime)
这个可以转成datetime 吗