关于一个日期查询问题~~~高分求教

[wangjinmin1982]

Select * From TB_NewsInfo where News_addtime like '%2004-6-30%' order by news_id desc

这条 语句是没错误的,但返回不到任何数据.这是一日期精确查询,数据库里的格式是2004-6-30 12:21:14 这种格式,现在是我要把 2004-6-30 这天的数据都查出来

请指导下

SELECT *
FROM tb_NewsInfo
WHERE (News_AddTime = CAST('2004-6-30' AS datetime)) 是错误的语法

我该怎么写呢?

[wangjinmin1982]

狂晕中,点快了,才给了20分
希望不要见怪~~~~~~~

[yongz_0]

Select * From TB_NewsInfo where datediff(dd,News_addtime,'2004-6-30' )=0 order by news_id desc

[TSD]

SELECT *
FROM tb_NewsInfo
WHERE (DATEDIFF([DAY],News_AddTime,'2005-3-10')=0)

[yongz_0]

access,sql server,oracle?

[TSD]

'2005-3-10' 改为你要指定的日期

[wangjinmin1982]

sql server

[wangjinmin1982]

SELECT *
FROM tb_NewsInfo
WHERE (DATEDIFF([DAY],News_AddTime,'2005-3-10')=0)
和
Select * From TB_NewsInfo where datediff(dd,News_addtime,'2004-6-30' )=0 order by news_id desc
用数据查询分析器,还是查寻不到信息,可是数据库里是有记录的啊

[wangjinmin1982]

哦,看错了,是对的,谢谢
TSD(因为你有而精彩) ( ) 信誉：96
和
yongz_0(涩男郎) ( ) 信誉：100
结帖