Re: Query on DATETIME field

Posted in 1998

Noel Griffin — Thu, 27 Aug 1998 22:18:13 +0100 — source: Informix-list mailing list archive (1991-1998)

1. Create and index on the DATETIME column 2. You can query rows quickly using just the DATE part of the column. 2.1 Use the DATAVALUE() function if using VB 2.2 Use the DATE() function if using 4GL or ESQL/C to strip the time part of the column. We use DATETIME YEAR TO SECOND in all our applications, but nearly allways have to report based on date ranges. No problems at all once you have an index.