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
.