Eine Einführung in
|
| SQLite | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to SQLite | ||
| none | ||
| DB2 | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to DB2 | ||
| Use a simple string to specify a DATE, TIME or TIMESTAMP literal. | ||
| MS Access | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to MS Access | ||
| Date and time literals may be specified using # for quotes: #1962-05-20# | ||
| PostgreSQL | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to PostgreSQL | ||
| none | ||
| Oracle | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to Oracle | ||
| The type TIME is not supported - however there is an INTERVAL that might do instead. | ||
| MS SQL Server | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to MS SQL Server | ||
| ||
| MySQL | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to MySQL | ||
| Use DATETIME in place of TIMESTAMP. TIMESTAMP may be used as a column type - but it means something totally different - it encourages "automatic marking" of insert or updates. MySQL Manual | ||
| Sybase | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to Sybase | ||
| Use DATETIME in place of TIMESTAMP. Use simple strings for DATE literals. | ||
| Mimer SQL | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to Mimer SQL | ||
| none | ||