Calculating actual date and time from eTCreateDate and eTCreateTime in Provisioning Directory.

book

Article ID: 51475

calendar_today

Updated On:

Products

DIRECTORY CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On SECURITY MISC CODES SINGLE SIGN ON - LEGACY CA Data Protection (DataMinder) CA User Activity Reporting

Issue/Introduction

Description:
In the Admin/Provisioning Directory, the eTCreateDate and eTCreateTime attributes contain odd numerical values.
For example:
eTCreateDate = 0000110013
eTCreateTime = 0004055600
How do I calculate the actual date and time stamps from these values?
Solution:
Internally, in Provisioning Directory, these values are stored as Julian date in "0000YYYDDD" format.
Where:
YYY is: current year - 1900 (the '-' represents minus sign)
DDD is: 3-digit day within the year, with leading zeros.
eTCreateDate attribute:
For example if you have: 0000108351
     YYY=108 (which is derived from 2008-1900=108, assuming the current year is 2008)
     DDD=351=16th December.
     So 0000108351 refers to December 16th, 2008.
Using sample in description of this technical document, you have 0000110013, which means:
     YYY=2010-1900=110
     DDD=013=13th January
     So 0000110013 refers to January 13th, 2010.
eTCreateTime attribute:
=-=-=-=-=-=-=-=-=-=-=-=
Time attributes are the number of 100th of seconds in the day.
For example if you have: 0004107500
This converts to: 11h24m35s (((11*60)+24)*60+35)*100 = 4107500 (i.e. 0004107500)
 
 



Environment

Release:
Component: ETRADM

Resolution

Please Update This Required Field