Match a range of dates

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#

DATE and TIME Operations

Date and time types

Format a date and time

Specify a date

Match a range of dates

Subtract dates

INTERVAL of time

Components of date

Date functions

Date arithmetics

Select the oldest person

Select a record with the latest date

YYYYMMDD date format

Getting the latest record