LispWorks User Guide and Reference Manual > 19 Common SQL > 19.6 Working with date fields

NextPrevUpTopContentsIndex

19.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 for details.


LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex