See the supported connectors for Application Integration.

NOW_IN_MILLIS function

NOW_IN_MILLIS function

Function Name	Description	Usage	Input parameter	Return value
NOW_IN_MILLIS	Returns the current Unix epoch time of the integration in milliseconds.	NOW_IN_MILLIS()	N/A	Unix epoch time in milliseconds

Note: When you format dates using the java.time.format.DateTimeFormatter class, ensure that you format the year in lowercase (yyyy) instead of uppercase (YYYY). The year in uppercase (YYYY) represents the year of the current week, whereas in lowercase (yyyy) represents the calendar year.

Supported data type

The NOW_IN_MILLIS function supports the following data type:

• Integer

Example: Get the current Unix epoch time in milliseconds and convert it to human-readable format.

Usage: NOW_IN_MILLIS().EPOCH_TO_HUMAN_READABLE_TIME("d MMM yyyy HH:mm:ss:SSS z","GMT")

Returns Unix epoch 1657783580839 and converts it to human-readable format.

Output: 14 Jul 2022 07:26:20:839 GMT

Recommendation

• Learn how to add and configure a Data Mapping task