Главная страница | назад

Article #10357: How to query dates using Day-Month-Year using local SQL

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

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.


11/1/99 is November 1, 1999.

11.1.99 is January 11, 1999.

Last Modified: 19-OCT-99