Eine Einführung in
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.
|Specific to Oracle|
|Oracle can be made to accept almost any format if we use the TO_DATE function. Details at Date Format Elements|