Comparing Dates in Queries

Use a comparison in the WHERE clause to select a set of rows that satisfy the search condition.

Listing Employees Born Before March 3, 1964

The following example shows the use of a date inequality search condition. Type the following:

SELECT Surname, BirthDate
FROM Employees
WHERE BirthDate < 'March 3, 1964'

Sybase IQ knows that the BirthDate column contains a date, and converts 'March 3, 1964' to a date automatically.