Eine Einführung in
SQL
Match a range of dates
SQLite
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN DATE '1980-05-20' AND DATE '1980-05-26'
Specific to SQLite
none
DB2
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN '1980-05-20' AND '1980-05-26'
Specific to DB2
none
MS Access
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN #20 May 1980# AND #26 May 1980#
Specific to MS Access
none
PostgreSQL
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN DATE '1980-05-20' AND DATE '1980-05-26'
Specific to PostgreSQL
none
Oracle
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN DATE '1980-05-20' AND DATE '1980-05-26'
Specific to Oracle
none
MS SQL Server
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN '1980-05-20' AND '1980-05-26'
Specific to MS SQL Server
none
MySQL
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN DATE '1980-05-20' AND DATE '1980-05-26'
Specific to MySQL
none
Sybase
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN DATE '1980-05-20' AND DATE '1980-05-26'
Specific to Sybase
none
Mimer SQL
The BETWEEN clause may be used with dates, numbers and strings.
SELECT * FROM totp WHERE wk BETWEEN DATE '1980-05-20' AND DATE '1980-05-26'
Specific to Mimer SQL
none