Previous Topic: Datetime FormatNext Topic: How to Change the Datetime Format


Supported Datetime Formats

CA User Activity Reporting Module supports the following datetime formats:

Pattern Letter

Description

Y

Indicates a year. The following are the possible values:

  • Two
  • Four

If the pattern letter number is two, the value is interpreted as two digits. For example, YY=11 for the year 2011.

If the pattern letter number is four, the value is interpreted as four digits. For example, YYYY=2011.

M

Indicates a month in the year. The following are the possible values:

  • One
  • Two
  • Three
  • Four

If the pattern letter number is one, the value is interpreted as one or two digits. For example, M=1 or 11.

If the pattern letter number is two, the value is interpreted as two digits. For example, MM=01.

If the pattern letter number is three, the value is interpreted as three letters. For example, MMM=Jan.

If the pattern letter number is four, the value is interpreted as full text. For example, MMMM=January.

D

Indicates a day in the month. The following are the possible values:

  • One
  • Two

If the pattern letter number is one, the value is interpreted as one or two digits. For example, D=1 or 11.

If the pattern letter number is two, the value is interpreted as two digits. For example, DD=01 or 11.

E

Indicates a day in a week. The following are the possible values:

  • Three
  • Four

If the pattern letter number is three, the value is interpreted as three letters. For example, EEE=Mon.

If the pattern letter number is four, the value is interpreted as full text. For example, EEEE=Monday.

A

Indicates a time format. The following are the possible values:

  • AM
  • PM

J

Indicates the hour on a 24-hour clock in the range 0–23.

H

Indicates the hour on a 24-hour clock in the range 1–24.

K

Indicates the hour on a 12-hour clock in the range 0–11.

L

Indicates the hour on a 12-hour clock in the range 1–12.

N

Indicates a minute in the hour. The following are the possible values:

  • One
  • Two

If the pattern letter number is one, the value is interpreted as one or two digits. For example, N=1 or 11.

If the pattern letter number is two, the value is interpreted as two digits. For example, NN=01 or 11.

S

Indicates a second in the minute. The following is the possible value:

  • Two

If the pattern letter number is two, the value is interpreted as two digits. For example, SS=01 or 11.

Q

Indicates a millisecond in the second. The following are the possible values:

  • Two
  • Three

If the pattern letter number is two, the value is interpreted as two digits. For example, QQ=01 or 11.

If the pattern letter number is three, the value is interpreted as three digits. For example, QQQ=001.

For example, if the current date is February 11, 2011 and the current time is 14.20.12 PM on a 24-hour clock, the datetime can be of the following formats: