Kbase 15242: ODBC - Format for Specifying Dates
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
ODBC - Format for Specifying Dates
We do not support Date datatypes, we convert them to strings. You
could do a string query, but must enclose it in double quotes instead
of single quotes.
select * from test where datum < "1995-09-01".
Also tested the following query in odbc test and also have tested this
query using MSQuery:
select * from order where pdate < "10/28/1990".
Progress Software Technical Support Note # 15242