使用ODBC联接数据库查询日期大家知道SQL要怎么写吗?
我这样子写哪里出错了
select hmb_dh,hmb_jh, hmb_jyrq, hmb_fkfs, hmb_fkkh, hmb_fkje, hmb_yhfs, hmb_yhkh, hmb_yhje, hmb_jyfs, hmb_gh, hmb_jysj from zbmbjy where 1=1 and hmb_jyrq Between '2005-2-8' and '2005-2-8'
我这样子写哪里出错了
select hmb_dh,hmb_jh, hmb_jyrq, hmb_fkfs, hmb_fkkh, hmb_fkje, hmb_yhfs, hmb_yhkh, hmb_yhje, hmb_jyfs, hmb_gh, hmb_jysj from zbmbjy where 1=1 and hmb_jyrq Between '2005-2-8' and '2005-2-8'
select hmb_dh,hmb_jh, hmb_jyrq, hmb_fkfs, hmb_fkkh, hmb_fkje, hmb_yhfs, hmb_yhkh, hmb_yhje, hmb_jyfs, hmb_gh, hmb_jysj from zbmbjy where (1=1) and (hmb_jyrq Between '2005-2-8' and '2005-2-8')
eg
select * from tablename where 日期={^2003-05-28}
方法可行。。谢谢。。