Layer7 Identity Management

Expand all | Collapse all

Need the date format of provisioning directory

Jump to Best Answer
  • 1.  Need the date format of provisioning directory

    Posted 09-07-2018 12:27 AM

    Hi All,

     

    can anyone know how the date is stored in provisioning directory. We have provisioning server 12.6.5 where the user creation data is showing as 2017-11-27 but in the backend it is stored as 0000117331. Similarly 2014-08-01 is stored as 0000114213.

     

    Need details like how it is getting converted into that number when it is storing the provisioning directory and how it is retrieving back as the date.

     

    Regards,

    Rajesh



  • 2.  Re: Need the date format of provisioning directory
    Best Answer

    Posted 09-07-2018 03:33 AM

    Hi Rajesh,

     

    This internal date format on Provisioning Directory is an internal Julian date in "0000YYYDDD" format.
    YYY is the year - 1900.
    DDD is a 3-digit Julian day within the year, with leading zeros (day-of-year starting with 1).

    e.g.:

    YYY=2017-1900=117
    DDD=27th Nov=331

     

    Many documentations exist on the web explaining on how to play in a program code with such a format.

     

    Regards,

    Philippe.