Paradox problem ! ! !

[crisamon]

I'm developing a web application that access data from a paradox 5 table via ODBC. I need to do a SQL query on date and time fields, like this:

SELECT * FROM TABLE2 WHERE DATE='09/12/2002' AND TIME='10:23:34'

These two fields are defined, inside the table, as DATE and TIME types. Comparing as strings doesn't work, the odbc paradox driver doesn't make convertions. So, how should I compare?

Thanks in advance.

[ir4z0r]

doesn't paradox provide sql-functions like date() and time()?

just guessing, try it anyway:
SELECT * FROM TABLE2 WHERE DATE=DATE(xyz) AND TIME=TIME(abc)