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.