Informix live query with selection on datetime field

Philippe Requilé

Delphi Developer

Fri, 17 Oct 2003 20:55:59 GMT

Informix live query with selection on datetime field

Hello,

I try to put a select statement on a datetime field.
When Requestlive:=False, the next lines are OK:
select * from Table where date(datetimefield) = "01/31/2001"
select * from Table where datetimefield = DATETIME(2001-01-31) YEAR TO DAY
select * from Table where datetimefield = MDY(01,31,2001)

I would like to put such a selection on a live query.
Anyone ideas?

Philippe Requil

Other Threads

1. Errors using Live Queries using DATETIME on Informix 7.3

2. Informix & DateTime Fields

3. Informix with datetime fields

4. SQL Queries against a DateTime Field

5. Problem querying Access DATETIME fields

6. Query on DateTime Field

7. How to Query Specific dateTime fields on ORACLE

8. SQL Query and DateTime Field accuracy problem.

9. Query DateTime Field

10. Informix and Datetime