求助！！！sqlserver varchar 转换date失败 高分相赠

Question

convert(varchar,a.TF_CK_TIME,120) as "date1",
convert(varchar(120),a.TF_CK_TIME,120) as "date1",
convert(datetime,a.TF_CK_TIME) as "date1",
等都试过了 无效

Value 27.307785543038175 cannot be converted to TIMESTAMP.
Value 2017-09-08 12:10 cannot be converted to TIMESTAMP.
球球大神 帮忙解决高分相赠

Answer 1

你报的错是 2017-08-18 17:17这个值不能修改为时间戳，你这样转来转去为什么不用date类型呢？，把数据库和实体类都用Date类型
select convert(datetime,'2005-12-25',120)

select convert(smalldatetime,'2005-12-25',120)\

select cast('2005-12-25' as datetime)

select cast('2005-12-25' as smalldatetime)
你试试这些