Export (0) Print
Expand All

WQL-Supported Time Formats

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

FormatDescription
hh[ ]{AP}MHour as shown on a twelve-hour clock, and AM or PM designation.

4 PM

hh:mmColon-delimited hour and minutes. No AM or PM designation.

3:23

hh:mm[ ]{AP}MColon-delimited hour and minutes, optional space, and AM or PM designation.

3:23 AM

hh:mm:ssColon-delimited hour, minutes and seconds. No AM/PM designation.

3:23:00

hh:mm:ss[ ]{AP}MColon-delimited hour, minutes and seconds, optional space, and AM/PM designation.

3:23:00PM

hh:mm:ss:uuuColon-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]uColon-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}MColon-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}MColon-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.

 

Related topics

WHERE Clause

 

 

Show:
© 2014 Microsoft