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

 Document ID : KB000051475 Last Modified Date : 14/02/2018 Show Technical Document Details
 Description:Currently in the Admin/Provisioning Directory we see attributes eTCreateDate and eTCreateTime that contain odd numerical values.For example:eTCreateDate = 0000110013eTCreateTime = 0004055600How do I calculate the actual date and time stamps from these values?Solution:The 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: 0004107500This converts to: 11h24m35s (((11*60)+24)*60+35)*100 = 4107500 (i.e. 0004107500)