SAP Knowledge Base Article - Public

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


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)/"


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:


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

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



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


SAP SuccessFactors HCM Core all versions