By default Common SQL converts DATE values to Common Lisp universal times. Therefore code like this returns Common Lisp universal times (that is, integers) where
MyDate
is a DATE field type:
(sql:select [MyDate] :from [MyTable] :where [= [id] 1])