Kbase 12384: Oracle & Progress: Date type in where clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Oracle & Progress: Date type in where clause
Date fields are difficult to use in the WHERE clause since Oracle
dates include a time portion and Progress dates do not.
To get around this we use the Oracle TRUNC function to eliminate the
time portioon from the comparision. As a side-effect, Oracle will
NOT use an index to do the selection.
One way around this: (cannot be running from compiled .r's)
Start up using -zod and Progress will not use the TRUNC function
thereby allowing Oracle to use the index (assuming one exists).
In this case, equality selections on dates will match if and only if
the time portion of the date is zero.
Progress Software Technical Support Note # 12384