WQL-Supported Time Formats
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. |