SAP Knowledge Base Article - Public

2439189 - Querying a Date via API it returns incomprehensible value which does not looks like a date

Symptom

An integration tool is reading information from the database.

Querying fields that represent dates in the system, the application returns sequence of numbers and not the date that you will expect.

Reproducing the Issue

For example:

querying the Application Date in the Application table you get something like this:

 "applicationDate": "/Date(1487092163000+0000)/"

Cause

The system is using  the Unix Time (also known as POSIX Time or Epoch Time) and value it represents the number of seconds (in our case: the milliseconds) that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970.

You can read more information here: https://en.wikipedia.org/wiki/Unix_time

Resolution

If you need to convert that value you can use one of the tools evailable online, for example:

http://www.onlineconversion.com/unix_time.htm

just remove "000+0000"  (we need to remove 000 because the full number represent the milliseconds and not the seconds)

and converto only the value "1487092163"

then you will get:   Tue, 14 Feb 2017 17:09:23 GMT


temp.png

Keywords

Date and Time Unix time POSIX time Epoch Time API , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem

Product

SAP SuccessFactors HCM Core all versions