20.6.1 Testing date values

Compare DATE values by formatting the date as a string in a date format that the database can parse. For example:

Note that it is not possible to lookup date values in the database using numeric values. This is because:

1. Common SQL cannot know that the field will be a date field until the results are returned, and
2. the database probably does not know about Common Lisp universal time.