20.6.3 DATE returned as string

Instead of universal time integers, you can obtain strings formatted by the database by modifying the MyDate database identifier, adding :string like this:

(sql:select [MyDate :string] :from [MyTable] :where [= [id] 1])

This avoids the overhead of converting DATEs to universal times and so may improve performance of your application.

See select in the LispWorks Reference Manual for details.

LispWorks User Guide - 11 Mar 2008