Comparing dates in queries

Sometimes you will not know exactly what value you are looking for, or you would like to see a set of values. You can use comparisons in the WHERE clause to select a set of rows that satisfy the search condition.

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.