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