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

1 Comment

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.

Label:

1 Response so far.

  1. daspeac says:
    12:22 PM

    get the word recovery utility to fix data corruption issues in the files of specified format

Post a Comment

Thank you for your comment.

Any request and idea are welcome.

Subscribe to: Post Comments (Atom)

CLICK TO REGISTER