我想获取日期为“ DATE”(交易日期)与“已编码日期”(实际日期)的交易数据,
我尝试将两个字段与交易日期相关联,但是问题是另一个字段具有时间戳,这意味着我无法与没有时间戳的其他字段相关
select
cast( cdvdate AS varchar(12) ) as Transaction_Date,cast( UpdateDate AS varchar(20) ) as Encoded_Date,ApprovedDate
from
cdvhdr
where
cdvdate != updatedate
我希望结果没有这样的交易日期和编码日期
Transaction_Date Encoded_Date ApprovedDate
Jan 4 2016 Jan 23 2016 10:54AM 2016-01-24 16:16:37.000
但是由于时间戳记,它在同一天显示结果
Transaction_Date Encoded_Date ApprovedDate
Jan 26 2016 Jan 26 2016 10:58AM 2016-01-26 13:42:32.000
Jan 26 2016 Jan 26 2016 11:07AM 2016-01-26 13:42:55.000
Jan 26 2016 Jan 26 2016 11:09AM 2016-01-26 13:41:49.000
Jan 26 2016 Jan 26 2016 11:11AM 2016-01-26 13:42:09.000