DateTime Date=new DateTime();
Date=DateTime.Now;
sql="selectID,Name from 表a where FDate between '"+Date+"' and DATEADD(day,1, '"+Date+"')";FDate为DateTime型的字段这句sql语句在Sql Server里是行的,在Access里不行,应该怎么写?
谢谢帮帮忙
Date=DateTime.Now;
sql="selectID,Name from 表a where FDate between '"+Date+"' and DATEADD(day,1, '"+Date+"')";FDate为DateTime型的字段这句sql语句在Sql Server里是行的,在Access里不行,应该怎么写?
谢谢帮帮忙
sql="select ID,Name from 表a where FDate between '"+Date+"' and DATEADD(day,1, '"+Date+"')";