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型以便运算?
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型以便运算?