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 emp_lname, birth_date
FROM employee
WHERE birth_date < 'March 3, 1964'

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