Eine Einführung in
|
| SQLite | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to SQLite | ||
| none | ||
| DB2 | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to DB2 | ||
| The DAYS function gives us the number of days since a long time ago. The string "yymmdd" includes the number of years, months and days since. | ||
| MS Access | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to MS Access | ||
| none | ||
| PostgreSQL | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to PostgreSQL | ||
| none | ||
| Oracle | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to Oracle | ||
| MS SQL Server | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to MS SQL Server | ||
| We can get the answer in days, or in years. MSDN documentation on DATEDIFF | ||
| MySQL | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to MySQL | ||
| We may use the TO_DAYS function which tells use how many days since year 0. See 6.3.4 Date and Time Functions for more details. | ||
| Sybase | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to Sybase | ||
| none | ||
| Mimer SQL | ||
|
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND
We want to know how long has it been since Tom Jones featured on TOTP. | ||
| Specific to Mimer SQL | ||
| none | ||