Match a range of dates

From SQLZOO
Jump to: navigation, search

Match a range of dates

schema:gisq

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'
SELECT * FROM totp
 WHERE wk BETWEEN '1980-05-20'
              AND '1980-05-26'
SELECT * FROM totp
 WHERE wk BETWEEN #20 May 1980#
              AND #26 May 1980#
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense