这个sql语句怎么写..

hanlen · 发表于 2002-1-23 20:15

sql server 里的应该是convert.
convert('2001-01-01',日期字段，120)

qianlei222 · 发表于 2002-2-22 15:29

Select * From TableName
Where DateDiff(DD,DateFieldName,'2001-12-12' )=0

candoor · 发表于 2002-3-17 00:04

最简单的是
select * from tablename where datefiled >='date' and datefiled<= 'date 23:59:59'
或者
select * from tablename where datefiled=>'date' and datefiled< dateadd (day,1,'date ')

这个sql语句怎么写..

我也正遭遇这种问题交流一下吧~

浏览过的版块