如何得到这样的数据

Question

两张表分别是：
A表：
字段 col001 内容为
2010-04-01 00:00:00.000
2010-04-02 00:00:00.000
2010-04-06 00:00:00.000
2010-04-07 00:00:00.000
2010-04-09 00:00:00.000
2010-04-12 00:00:00.000B表：
字段 col003 内容为
2010-04-01 08:53:00
2010-04-02 08:50:00
2010-04-06 08:58:00
2010-04-12 08:59:00我这样写
select a.*,b.* from shijian a left join kqsj b on substring(a.col001,1,10)=substring(b.col003,1,10)
始终都是：
2010-04-01 00:00:00.000 CD101 2010-04-01 08:53:00
2010-04-02 00:00:00.000 CD101 2010-04-02 08:50:00
2010-04-06 00:00:00.000 CD101 2010-04-06 08:58:00
2010-04-12 00:00:00.000 CD101 2010-04-12 08:59:00如何才得到这样的内容：
2010-04-01 00:00:00.000 CD101 2010-04-01 08:53:00
2010-04-02 00:00:00.000 CD101 2010-04-02 08:50:00
2010-04-06 00:00:00.000 CD101 2010-04-06 08:58:00
2010-04-07 00:00:00.000
2010-04-09 00:00:00.000
2010-04-12 00:00:00.000 CD101 2010-04-12 08:59:00

Answer 1

select a.*,b.* from shijian a left join kqsj b on datediff(dd,a.col001,b.col003)=0

Answer 2

select a.*,b.* from shijian a left join kqsj b 
on convert(varchar(10),a.col001,120)=convert(varchar(10),b.col003,120)