timestampInMilliseconds (Function)
Returns the system time or the given time in milliseconds.
Syntax
<LONG> time:timestampInMilliseconds()
<LONG> time:timestampInMilliseconds(<STRING> date.value, <STRING> date.format)
<LONG> time:timestampInMilliseconds(<STRING> date.value)
Query Parameters
Name | Description | Default Value | Possible Data Types | Optional | Dynamic |
---|---|---|---|---|---|
date.value | The value of the date. For example, 2014-11-11 13:23:44.657 , 2014-11-11 , 13:23:44.657 . | Current system time | STRING | Yes | Yes |
date.format | The format of the date value provided. For example, yyyy/MM/dd HH:mm:ss.SSS . | `yyyy-MM-dd HH:mm:ss.SSS` | STRING | Yes | Yes |
Example 1
time:timestampInMilliseconds()
Returns the system current time in milliseconds.
Example 2
time:timestampInMilliseconds('2007-11-30 10:30:19', 'yyyy-MM-DD HH:MM:SS')
Converts 2007-11-30 10:30:19
in yyyy-MM-DD HH:MM:SS
format to
milliseconds as 1170131400019
.
Example 3
time:timestampInMilliseconds('2007-11-30 10:30:19.000')
Converts 2007-11-30 10:30:19
in yyyy-MM-DD HH:MM:ss.SSS
format to
milliseconds as 1196398819000
.