间隔天数
大家看这个sql错到那里了,谢谢
SQL = "select * from tj where DateDiff("d", firtime1, firtime2 )>20 order by firtime2 desc"
firtime1, firtime2 都是数据库中的字段,格式2000-02-12
[此贴子已经被作者于2007-5-24 10:49:39编辑过]
大家看这个sql错到那里了,谢谢
SQL = "select * from tj where DateDiff("d", firtime1, firtime2 )>20 order by firtime2 desc"
firtime1, firtime2 都是数据库中的字段,格式2000-02-12
[此贴子已经被作者于2007-5-24 10:49:39编辑过]