19.6.2 DATE returned as universal time

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

19.6.2 DATE returned as universal time

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])

19.6.2.1 Timezone of returned DATEs

LispWorks User Guide and Reference Manual - 21 Dec 2011