Kbase P61488: How WHERE clause on Oracle DATE column are handled
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How WHERE clause on Oracle DATE column are handled
GOAL:
Why range match (BETWEEN) are used on equality with a DATE?
FIX:
Oracle datatype DATE has a TIME information, Progress datatype DATE has not such additional information.
Matching the Progress DATE '01/01/2001' are the Oracle DATEs between 01-01-2001 0:00:00 and 01-01-2001 23:59:59.