SELECT * FROM tabel where T_Taxis> 2007-1-22 13:47:22 出错
T_Taxis 为时间型
SELECT *
FROM Product_Type where T_Taxis> 2007-1-22 正确
怎么写正确的sql语句呀
为什么加分秒就出错? 急 帮帮忙
------解决方案--------------------------------------------------------
SELECT * FROM tabel where T_Taxis> to_date( '2007-1-22 13:47:22 ', 'YYYY-MM-DD HH24:MI:SS ')
------解决方案--------------------------------------------------------
SELECT * FROM tabel where Convert(varchar(50),T_Taxis,120)> '2007-1-22 13:47:22 '