NextPrevUpTopContentsIndex Timezone of returned DATEs

Common SQL creates universal time values from DATE fields assuming that the database contains times in Coordinated Universal Time (UTC). That is, as if by passing time-zone 0 to encode-universal-time . To decode the values consistently with this encoding, pass time-zone 0 to decode-universal-time .

If the database contains times in a different timezone, then the integer time-zone needs to be adjusted by adding an appropriate multiple of 3600 before calling decode-universal-time .

LispWorks User Guide - 11 Mar 2008