SQL > SQL Date Format

Date formats in SQL statements

Contrasting the delimited text import, the SQL procedures are strictly linked to the rules of the BDE LocalSQL.
Using BDE, with SQL procedures like INSERT INTO or comparative SQL procedures, the Date format must comply to either the by BDE universally accepted US format (MM/DD/YYYY) or to the currently selected system Short Date format, as for example DD.MM.YYYY.

Thus, universally accepted by BDE, you may insert the date for New Year Eve as:

INSERT INTO TableName (DateField) VALUES ('12/31/2026');

So, creating a SQL INSERT INTO script with date values, using the MM/DD/YYYY format is recommended.

The ISO date format will be accepted only if it is selected as the current system Short Date format (as used e.g. in Sweden).

See also Date format for Delimited Text Import and Text Export