TimeStamp Understanding

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.2p5

I am looking for the correct correlations to a real timestamp based on what is currently in the database. I have been looking on Compass how this is configured, but can anyone tell me how to read the OOB timestamps within IIQ?

Example: Created:“1519065955175”

2

Hi @Alyson_Trad,

IIQ the timestamp is in milliseconds and the value that you see on the debug is the same that you find into DB.
About Created and Modified that are stadard attriibute you can find own column:

image
image272×190 8.83 KB

If manage other identity attribute like Date, that will be stored like a Timestamp ion millisend, instead like a string.

If you want correlate a timestamp with the value stored into IIQ, you must look the format of the timestamp, because it could be in seconds, milliseconds, microseconds and nanoseconds. At end you must divide or multiply until you have the same size.

3 Likes
3

Hi @Alyson_Trad,

IdentityIQ is storing the date value as Unix epoch time in Milliseconds.
The timestamp 1519065955175 is the number of milliseconds from January 1, 1970, 00:00:00 UTC.

To convert the timestamp 1519065955175 to a human-readable date, you can use epoch converter Epoch converter.

Also you can use java code to convert.

  long timestamp = 1519065955175L; 
  Date date = new Date(timestamp);
  SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  return sdf.format(date);
2 Likes