SQL
zoo.net
Match a range of dates
SQLite
DB2
Ingres
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
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
Related links:
DATES
Date and time types.
Format a date and time.
Specify a date (date literal).
Match a range of dates
Subtract dates.
Add days to a date. INTERVALS. Also subtract, also years, months, hours ...
Components of a date: such as the year or the month
Group by day of the week (using date functions)
Group by day of the week (using arithmetic)
How can I select the oldest person in the table PERSON by birthday?
Select a record with the latest date
How to format a date like yyyymmdd
How can I get the Lastest record from SQL