The time() operator can accept either absolute dates or relative dates. Such date strings are processed on the Rational® Synergy server using the locale and time zone of the server, not of the client. Relative dates use the time zone of the server and meaning of 00:00:00 for the start of the day. When the server machine is using a different time zone from the client machine, which can cause unexpected results, especially for relative dates.
The time() operator accepts any of the following formats:
The full four-digit year number must be supplied.
The month, day, hour, minute, and seconds fields must be present and must be exactly two digits, with a leading zero if necessary.
The year, month, and day fields must be separated by a single dash (-).
The date and time must be separated by a single uppercase T.
The time fields must be separated by a single colon (:).
The time zone field must be present, and can be either a single uppercase Z for UTC (GMT) time, or a plus (+) or minus (-) character followed by an offset from UTC.
The offset from UTC is in hours (two digits) and minutes (two digits); the hours and minutes might be separated by an optional colon (:) separator. Thus, -0500 and -05:00 are both valid time zone fields.
'-0:0:0:0' means the start of today in the time zone of the server
'+0:0:0:0' means midnight tonight in the time zone of the server
'-1:18:0:0' means 6 A.M on the day before yesterday in the time zone of the server
'-2:0:0:0' means the start of day before yesterday in the time zone of the server
'-2:8:0:0' means 4 P.M. three days ago in the time zone of the server
There is an advantage to using the ISO8601 format for absolute dates. When the time zone is explicitly specified, the date is explicitly defined so that it is not dependent on the time zone or locale of the server.