Edit

WQL-Supported Time Formats

  • Article

In addition to the WMI DATETIME format, the following date formats are supported for use in the WQL WHERE clause.

Format Description
hh[ ]{AP}M
 Hour as shown on a twelve-hour clock, and AM or PM designation.
4 PM
hh:mm
 Colon-delimited hour and minutes. No AM or PM designation.
3:23
hh:mm[ ]{AP}M
 Colon-delimited hour and minutes, optional space, and AM or PM designation.
3:23 AM
hh:mm:ss
 Colon-delimited hour, minutes and seconds. No AM/PM designation.
3:23:00
hh:mm:ss[ ]{AP}M
 Colon-delimited hour, minutes and seconds, optional space, and AM/PM designation.
3:23:00PM
hh:mm:ss:uuu
 Colon-delimited hour, minutes and seconds, and three-digit offset that indicates the number of minutes that the originating time zone deviates from UTC.
hh:mm:ss:[[u]u]u
 Colon-delimited hour, minutes and seconds; and one, two, or three-digit offset that indicates the number of minutes that the originating time zone deviates from UTC.
hh:mm:ss:uuu[ ]{AP}M
 Colon-delimited hour, minutes and seconds, three-digit offset that indicates the number of minutes that the originating time zone deviates from UTC, and AM or PM designation.
hh:mm:ss:[[u]u]u[ ]{AP}M
 Colon-delimited hour, minutes and seconds; one, two, or three-digit offset that indicates the number of minutes that the originating time zone deviates from UTC; and AM or PM designation.

WHERE Clause