select * from Table1 where datetime<=#2003-7-11 11:11:11#
select * from Table1 where datetime<=#2003-7-11 11:11:11# 或者DateValue('2003-7-11 11:11:11')
select * from Table1 where datetime<=#2003-7-11 11:11:11#
select * from Table1 where datetime<=strtodatetime('2003-7-11 11:11:11'); 用数据库字符窜到日期转换函数,函数在SQL里作为一般字符!
谢谢! select * from Table1 where datetime<=#2003-7-11 11:11:11# 出错 DateValue('2003-7-11 11:11:11') 通过
select * from Table1 where datetime<=#2003-7-11 11:11:11# 出错 不认识“#”DateValue('2003-7-11 11:11:11') 通过,但好像只能比较日期,不能比较时间! 恳请大家到帮忙!
select * from Table1 where datetime<=Cast('2003-7-11 11:11:11' as DateTime);
请大家看看:时间部分出错,怎么解决? Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+ DateTimeToStr(Now))
先定义一字符串变量把DateTimeToStr(Now)保存,在加入到query.sql中 var t_str:string begin t_str:=DateTimeToStr(Now); Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='); Query.SQL.Add.(t_str);
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ 'DateTimeToStrNow)+')')
sorry!多了一个' Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ DateTimeToStrNow)+')')
怎么搞的,又错啦: 少了(, Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ DateTimeToStr(Now)+')')
查询小于某一日期的记录:时间就不要吧??? Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ DateTimeToStr(trunc(Now))+')')
要是用到别的数据库,用数据库函数好一点。 试试这样: Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <=:time'); query.parambyname('time').asdatetime:=now; query.open;
或者DateValue('2003-7-11 11:11:11')
用数据库字符窜到日期转换函数,函数在SQL里作为一般字符!
select * from Table1 where datetime<=#2003-7-11 11:11:11# 出错
DateValue('2003-7-11 11:11:11') 通过
恳请大家到帮忙!
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+ DateTimeToStr(Now))
var
t_str:string
begin
t_str:=DateTimeToStr(Now);
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <=');
Query.SQL.Add.(t_str);
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ DateTimeToStrNow)+')')
少了(,
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ DateTimeToStr(Now)+')')
还是通不过:不认识field('20:11') // 2003-7-18 17:20:11 '20:11' 是分:秒
没用过ACCESS,
能不能考虑一下
Between ... and
Between ... and 也不行,它是不认识 2003-7-18 17:20:11这种格式或者是把空格以后的当作另外的字段!需要函数或...解决!
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <='+'strtodatetime('+ DateTimeToStr(trunc(Now))+')')
试试这样:
Query.SQL.Add('select * from SmsSend where flag in (3,4) and DateTime <=:time');
query.parambyname('time').asdatetime:=now;
query.open;