MsToDate
Description
Converts long type argument values representing a timestamp in milliseconds from January 1, 1970, 00:00:00 UTC to its corresponding date. A new column is created for the results.
Many databases and other applications may use Unix/Epoch time which posts dates as a long value in milliseconds. Use this function to convert that long value into a date.
Use
- Argument:
- Select an argument. (Long)
- Output field name:
- Enter an output field name.
Example
| Long value | MSTODATE() returns |
|---|---|
| 1644599656498 | 2022-02-11 18:14:16.498 |