Report Date/Time Format

A time period is required for certain types of endpoints. For example, endpoints in the reporting service typically require a time period to be defined for the statistical information that will be returned.

Type Format

More Information

Date

YYYY-MM-DD

Identifies a date.

Date/Time

YYYY-MM-DDThh:mm:ss

Identifies a date and time.

Time (i.e., Thh:mm:ss) is optional. If time is not specified, then a default time (i.e., 00:00:00) will be used.

Date/Time (Extended)

YYYY-MM-DDThh:mm:ss:ffffffZ

Rate Limiting, Report Builder, and WAF use this format to define a timestamp that is precise to the millisecond.

Date/Time (Extended II)

YYYY-MM-DDThh:mm:ss.ffffffZ

RTLD WAF uses this format to define a timestamp that is precise to the millisecond.

The variables used for the date and the date/time formats are described below.

VariableA variable represents a value that must be replaced. A variable consists of either a URL segment (e.g., "0001" in /0001/) or a query string value (e.g., "3" in mediaTypes=3). Description

YYYY

Represents a year in the Gregorian calendar using a four digit number (e.g., 2024).

MM

Represents a two digit month between 01 (January) and 12 (December).

DD

Represents a two digit day between 01 and 31.

T

Indicates a delimiter between date and time. This delimiter is only required if you would like to specify a time. Keep in mind that time must be specified using 24-hour clock notation in UTC.

hh

Represents a two digit hour between 00 (midnight) and 23 (11 p.m.).

mm

Represents the number of minutes into the specified hour. Minutes should be specified using two digits between 00 and 59.

ss

Represents the number of seconds into the specified minute. Seconds should be specified using two digits between 00 and 59.

ffffff

Represents the millionths into the specified second. This value should be specified using six digits between 000000 and 999999.

Z

Represents UTC time.

More Information