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=
![Stick Out Tongue :P :P](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
AND START_DATETIME>
![Big Grin :D :D](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
AND END_DATETIME<
![Big Grin :D :D](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
其中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=
![Stick Out Tongue :P :P](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
AND START_DATETIME>:S_DT ************估计这里有错
AND END_DATETIME<:E_DT