milliseconds()
This function returns the number of milliseconds from 1970-01-01 00:00:00 UTC to a given Date/timestamp in parameter a.
The Integration Server time zone is used to calculate the UTC time of date a. Then, the difference between this calculated UTC time and 01.01.1970 00:00:00 UTC is calculated, which is then transformed into milliseconds. See examples below.
Parameters
|
Parameter |
Description |
|
a |
Date/timestamp. Note: If no date is specified or an invalid value (e.g. some random string), the current date (with time) is used. |
Examples
Current timezone of the Integration Server: Europe/Berlin (CET = UTC+1)
|
Parameter a |
Result |
|
2005-02-07 12:57:59.996 |
1107777479996 |
|
1970-01-01 00:00:00.000 |
-3600000 |
|
1970-01-01 01:00:00.000 |
0 |
|
1970-01-01 02:00:00.000 |
3600000 |