LispWorks User Guide and Reference Manual > 19 Common SQL > 19.6 Working with date fields > 19.6.2 DATE returned as universal time

NextPrevUpTopContentsIndex

19.6.2.1 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 and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex