sql语句：查询时间段记录问题

[haha_ling]

我在做时间段记录查询时，用下面两种方法时，都取不到2008-3-4的记录，请高手指点
select * from Trade where account = '10000002 ' and trade_date >= '2008-3-2' and trade_date <= '2008-3-4'
select * from Trade where account = '10000002 ' and trade_date between '2008-3-2' and '2008-3-4'

[wlinglong]

SQL数据库吧 日期的格式应该是DATETIME类型
select * from Trade where account = '10000002 ' and trade_date > = '2008-3-2' and trade_date <= '2008-3-4 23:59:59'
select * from Trade where account = '10000002 ' and trade_date between '2008-3-2' and '2008-3-4 23:59:59'

[wzy_love_sly]

select * from Trade where account = '10000002 ' 
and trade_date > = '2008-3-2' and trade_date  <= dateadd(d,1,'2008-3-4')

[Limpire]

select * from Trade where account = '10000002 ' and trade_date > = '2008-3-2' and trade_date  <= '2008-3-5' -- '2008-3-4'
select * from Trade where account = '10000002 ' and trade_date between '2008-3-2' and  '2008-3-5' -- '2008-3-4'

[wzy_love_sly]

select * from Trade where account = '10000002 ' 
and trade_date > = '2008-3-2' and trade_date  < dateadd(d,1,'2008-3-4')

< dateadd(d,1,'2008-3-4')该是小于最后日期

[YanpingLuck]

你的日期有时分秒吧？

[djhai]

select * from Trade where account = '10000002 ' and trade_date > = '2008-3-2 00:00:00' and trade_date <= '2008-3-4 23:59:59'
select * from Trade where account = '10000002 ' and trade_date between '2008-3-2 00:00:00' and '2008-3-4 23:59:59'

[haha_ling]

恩
但我不需要时分秒

[haha_ling]

出来了
谢谢

[haha_ling]

如果我两个时间为变量
并且是yyyy-mm-dd样式
该怎么办呢

[-狙击手-]

接分