How to query dates using Day-Month-Year using local SQL

By: Quinn Wildman

Abstract: Separate values with . instead of / to get Day-Month-Year

Question:
How do I query a Paradox or dBASE table using Day-Month-Year instead of Month-Day-Year?

Answer:
The local SQL engine uses the separator to decide the format of a date. A / is interpreted as M/D/Y. A . is interpreted as D.M.Y.

Examples:

11/1/99 is November 1, 1999.

11.1.99 is January 11, 1999.


Server Response from: ETNASC03