Eine Einführung in

SQL

Insert a date.

Oracle

The format of dates can be very tricky. Most implementations are fairly robust in what will be accepted - but a date such as 01-02-03 might be interpreted in different ways in different countries.

Using a three character month and a four digit year in single quotes (such as '01 Mar 1997') works safely with most systems other than MySQL.

Execute tidy up code silently


Specific to Oracle
Oracle can be made to accept almost any format if we use the TO_DATE function. Details at Date Format Elements