B
bjwh
Unregistered / Unconfirmed
GUEST, unregistred user!
SELECT * Form LEAVE
WHERE PERSON=ERSON
AND START_DATETIME>ATETIME_MIN
AND END_DATETIME<ATETIME_MAX
其中DATETIME_MIN,DATETIME_MAX为TDateTime型变量值,然而START_DATETIME,
END_DATETIME为Paradox中的字符型字段,我如何在SQL中实现将START_DATETIME,END_DATETIME转化为TDateTime型以便运算?
Q_leave.ParamByName('Person').AsString:=person_id;
Q_leave.ParamByName('s_dt').AsString:=datetimetostr(late_time);
Q_leave.ParamByName('e_dt').AsString:=datetimetostr(early_time);
Q_leave.Prepare;
这是Q_leave的SQL:
Select * from "d:/kqdb/leave.db"
WHERE PERSON=ERSON
AND START_DATETIME>:S_DT ************估计这里有错
AND END_DATETIME<:E_DT
WHERE PERSON=ERSON
AND START_DATETIME>ATETIME_MIN
AND END_DATETIME<ATETIME_MAX
其中DATETIME_MIN,DATETIME_MAX为TDateTime型变量值,然而START_DATETIME,
END_DATETIME为Paradox中的字符型字段,我如何在SQL中实现将START_DATETIME,END_DATETIME转化为TDateTime型以便运算?
Q_leave.ParamByName('Person').AsString:=person_id;
Q_leave.ParamByName('s_dt').AsString:=datetimetostr(late_time);
Q_leave.ParamByName('e_dt').AsString:=datetimetostr(early_time);
Q_leave.Prepare;
这是Q_leave的SQL:
Select * from "d:/kqdb/leave.db"
WHERE PERSON=ERSON
AND START_DATETIME>:S_DT ************估计这里有错
AND END_DATETIME<:E_DT