日期類型格式這樣用好,加入控制datetimepicker1SELECT EventNo, Event_Date FROM Events WHERE Event_Date >=:date1 Order by Event_Date //Date1類值為stringParams[0].AsString := FormatDateTime('yyyy-mm-dd',datetime1.DateTime); ...
SELECT EventNo, Event_Date FROM Events WHERE Event_Date >= FormatDateTime('yyyy-mm-dd',StrToDate('2003-02-02')) 或者: SELECT EventNo, Event_Date FROM Events WHERE Event_Date >=Int(StrToDate('2003-02-02'))
SELECT EventNo, Event_Date FROM Events WHERE Event_Date >= FormatDateTime('yyyy-mm-dd',StrToDate('2003-02-02'))
如果FieldRQ设置成日期型,在开发的时候就必须规定好它的格式!而且在相关的操作中比较烦琐一点;
如果FieldRQ设置成字符型,说不定会简单一点。
个人见解,仅供参考......
FROM Events
WHERE Event_Date >=:date1 Order by Event_Date //Date1類值為stringParams[0].AsString := FormatDateTime('yyyy-mm-dd',datetime1.DateTime);
...
FROM Events
WHERE Event_Date >= FormatDateTime('yyyy-mm-dd',StrToDate('2003-02-02'))
或者:
SELECT EventNo, Event_Date
FROM Events
WHERE Event_Date >=Int(StrToDate('2003-02-02'))
FROM Events
WHERE Event_Date >= FormatDateTime('yyyy-mm-dd',StrToDate('2003-02-02'))