Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |