eTPasswordUpdateTime and eTPasswordUpdateDate Attribute Human-Readable Format Conversion

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

Identity Manager Provisioning Server uses specific internal formats for password metadata attributes such as eTPasswordUpdateTime and eTPasswordUpdateDate. These attributes are critical for auditing password changes and enforcing password age policies. Understanding how to decode these values allows administrators to verify the exact timing of password updates using standard date and time conventions.

Administrators see numerical strings like 0000121348 (Date) or 0006337200 (Time) in the user store and require a method to translate them into human-readable timestamps.

Environment

Identity Manager 14.x & 15

Resolution

The attributes follow a specific numeric encoding scheme. Use the logic below to decode the values:

Decoding eTPasswordUpdateDate The value (e.g., 0000121348) is an ordinal date format:

• First 3 digits (121): The number of years since 1900. (e.g., 1900 + 121 = 2021).
• Next 3 digits (348): The number of days into that year. (e.g., the 348th day of 2021 is December 14th).

Decoding eTPasswordUpdateTime The value (e.g., 0006337200) represents the time elapsed since midnight:

• Format: The value is the total number of 1/100ths of a second passed since 00:00:00.
• Example Calculation: 0006337200 / 100 = 63,372 seconds.
  • 63,372 seconds = 17 hours, 36 minutes, and 12 seconds.

Additional Information

For more details on ordinal date structures, refer to the Ordinal Date (ISO 8601) documentation.