问一个关于时间函数的基本问题

[pgz_007]

我想率选出两个表中退料时间(tlsj)不同的所有记录,(wheret tlb.tlsj<>tlmxb.tlsj)
可是这两个列的记录很多都是日期相同(同一天),但当天的时间却不同.我想率选数据的时候去掉时分秒只保留年月日.比如把记录中的 2007-12-28 10:37:10.403 ,变成2007-12-28再率选.请问该用什么函数?我的sql语句该怎么写?
原始sql语句如下
select tlb.tlbhid,tlb.tlsj,tlmxb.tlsj from tlmxb left join tlb on tlb.tlbhid=tlmxb.tlbhid wheret tlb.tlsj<>tlmxb.tlsj

发现用convert(varchar(10),'2007-12-28 10:37:10.403',110) 过后还是会有时间,不过都变成0了(2007-12-28 00:00:00.000)

[zhouchunyu]

select convert(varchar(10),'2007-12-28 10:37:10.403',120)

查询结果是: 2007-12-28

[liangCK]

convert(varchar(10),'2007-12-28 10:37:10.403',120)

[-狙击手-]

convert(varchar(10),'2007-12-28 10:37:10.403',120)

[dobear_0922]

select   tlb.tlbhid,tlb.tlsj,tlmxb.tlsj   
from   tlmxb   left   join   tlb   on   tlb.tlbhid=tlmxb.tlbhid   
where  datediff(d, tlb.tlsj, tlmxb.tlsj)<>0 

[dawugui]

select tlb.tlbhid,tlb.tlsj,tlmxb.tlsj from tlmxb left join tlb on tlb.tlbhid=tlmxb.tlbhid wheret convert(varchar(10),tlb.tlsj,120) <> convert(varchar(10),tlmxb.tlsj ,120)

[dobear_0922]

用datediff比convert好，，，

[free1879]

select convert(varchar(10),'2007-12-28   10:37:10.403',126)
--or
select convert(varchar(10),'2007-12-28   10:37:10.403',127)


--result

----------
2007-12-28

(1 row(s) affected)


----------
2007-12-28

(1 row(s) affected)

[dawugui]

select tlb.tlbhid,tlb.tlsj,tlmxb.tlsj from tlmxb left join tlb on tlb.tlbhid=tlmxb.tlbhid where convert(varchar(10),tlb.tlsj,120) <> convert(varchar(10),tlmxb.tlsj ,120) 
select tlb.tlbhid,tlb.tlsj,tlmxb.tlsj from tlmxb left join tlb on tlb.tlbhid=tlmxb.tlbhid where datediff(day,tlb.tlsj,tlmxb.tlsj) <> 0 

[wzy_love_sly]

select   tlb.tlbhid,tlb.tlsj,tlmxb.tlsj   from   tlmxb   left   join   tlb   on   tlb.tlbhid=tlmxb.tlbhid   wheret   datediff(tlb.tlsj,tlmxb.tlsj)=0

[wzy_love_sly]

select   tlb.tlbhid,tlb.tlsj,tlmxb.tlsj   from   tlmxb   left   join   tlb   on   tlb.tlbhid=tlmxb.tlbhid   wheret   datediff(dd,tlb.tlsj,tlmxb.tlsj)=0--少写个dd

[pgz_007]

揭帖

[lqpower]

select 时间=convert(varchar(10),日期类型字段,121)