SQLzoo: Insert a date.

Insert a date.

SQLite

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 SQLite

All data types are ignored, simple strings are used. Given this you should use 'yyyy-mm-dd', your dates will at least be ordered.

Execute tidy up code silently

DROP TABLE t_x

DB2
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATE); DELETE FROM t_x; INSERT INTO t_x VALUES ('Ryka', '1997-03-01'); SELECT * FROM t_x
Specific to DB2
none

MS Access
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATETIME); INSERT INTO t_x VALUES ('Ryka','01 Mar 1997'); INSERT INTO t_x VALUES ('Olly',#25 May 1985#); SELECT * FROM t_x
Specific to MS Access
When used within VBA Access likes dates to be enclosed in hash signs... #20 May 1962#

PostgreSQL
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 DROP TABLE t_x
Specific to PostgreSQL

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 DROP TABLE t_x INSERT INTO t_x VALUES ('Ryka','01 Mar 1997'); INSERT INTO t_x VALUES ('Milly', TO_DATE('July 9, 1995', 'Month dd, YYYY, HH24:MI')); SELECT * FROM t_x
Specific to Oracle
Oracle can be made to accept almost any format if we use the TO_DATE function. Details at Date Format Elements

MS SQL Server
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATETIME); INSERT INTO t_x VALUES ('Ryka','01 Mar 1997'); SELECT * FROM t_x
Specific to MS SQL Server
none

MySQL
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATE); INSERT INTO t_x VALUES ('Ryka','1997-03-01'); INSERT INTO t_x VALUES ('Impos','1997-09-31'); SELECT * FROM t_x
Specific to MySQL
MySQL only accepts dates in the format yyyy-mm-dd. Be warned that it will accept dates that don't exist - such as 31st September. "30 days hath September..."

Sybase
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATE); INSERT INTO t_x VALUES ('Ryka', DATE '1997-03-01'); SELECT * FROM t_x
Specific to Sybase
none

Mimer SQL
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATE); INSERT INTO t_x VALUES ('Ryka', DATE '1997-03-01'); SELECT * FROM t_x
Specific to Mimer SQL
none

Eine Einführung in SQL

Insert a date.

Eine Einführung in

SQL