Date/Time

The Date/Time format in queries can include hours, minutes, and seconds, and can be specified in this way:

yyyy.mm.dd.hh.mm.ss

You can omit anything starting from the right; for example, you can omit seconds, or seconds and minutes.

Note:    The time must be in the 24 hour clock format.

If you specify hh.mm.ss, they must be in UTC time (GMT with no daylight savings), where the separator can be any separator character, and each separator can be a different character. All of the following would work:

yyyy/mm/dd/hh/mm/ss
yyyy.mm.dd.hh.mm.ss
yyyy/mm/dd.hh.mm.ss
yyyy/mm/dd,hh:mm:ss

Example

SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_UPDATE_TS > '2000.01.11.18:00:00'

SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_UPDATE_TS != '2000.01'