search cancel

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


Article ID: 51475


Updated On:


CA 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 CA Security Command Center CA Data Protection (DataMinder) CA User Activity Reporting


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?
Internally, in Provisioning Directory, these values are stored as Julian date in "0000YYYDDD" format.
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:
     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)


Component: ETRADM


Please Update This Required Field